PSP Org. Default Labor Schedule

Description
Categories: BI Publisher, Human Resources
Application: Labor Distribution
Source: PSP: Org. Default Labor Schedule Report (XML)
Short Name: PSPLSODR_XML
DB package: PSP_PSPLSODR_XMLP_PKG
SELECT		hou.organization_id,
		hou.name,
		pdls.project_id,
		pdls.award_id,
		pdls.expenditure_organization_id,
		pdls.expenditure_type,
		pdls.task_id,
		pdls.gl_code_combination_id,
		pdls.set_of_books_id,
		pdls.schedule_begin_date,
		pdls.schedule_end_date,
		pdls.schedule_percent,
		nvl(org_schedule_id, -99)  org_schedule_id,
PSP_PSPLSODR_XMLP_PKG.CF_GL_DESCFORMULA(pdls.gl_code_combination_id) CF_GL_DESC,
PSP_PSPLSODR_XMLP_PKG.CF_TASK_NAMEFORMULA(pdls.project_id,pdls.task_id) CF_TASK_NAME,
PSP_PSPLSODR_XMLP_PKG.CF_ORG_NAMEFORMULA(pdls.expenditure_organization_id) CF_ORG_NAME,
PSP_PSPLSODR_XMLP_PKG.CF_AWARD_NUMBERFormula(pdls.award_id) CF_AWARD_NUMBER,
PSP_PSPLSODR_XMLP_PKG.CF_PROJECT_NUMBERFORMULA(pdls.project_id) CF_PROJECT_NUMBER,
PSP_PSPLSODR_XMLP_PKG.CF_sch_begin_date_dispFormula(pdls.schedule_begin_date,:CF_date_format) CF_SCH_BEGIN_DATE_DISP,
PSP_PSPLSODR_XMLP_PKG.CF_sch_end_date_dispFormula(pdls.schedule_end_date,:CF_date_format) CF_SCH_END_DATE_DISP,
PSP_PSPLSODR_XMLP_PKG.CF_ORG_SCHEDULE_IDFORMULA(nvl(org_schedule_id, -99)) CF_ORG_SCHEDULE_ID
FROM		psp_default_labor_schedules    pdls,
		hr_organization_units		hou
WHERE			&p_organization_id
AND		hou.organization_id			=	pdls.organization_id(+)
AND		nvl(pdls.schedule_begin_date, :p_end_date)	<=	:p_end_date
AND		nvl(pdls.schedule_end_date, :p_begin_date) >=	:p_begin_date
AND		hou.business_group_id		=	:p_business_group_id
AND                           (( pdls.set_of_books_id                    	 =	:p_set_of_books_id)
		OR
		(pdls.set_of_books_id		IS  NULL)
	                )
ORDER BY 2 ASC , hou.name
Parameter Name SQL text Validation
PSP_REPORT_TYPE
 
P_SET_OF_BOOKS_ID
 
Number
P_BUSINESS_GROUP_ID
 
Number
End Date
 
Date
Begin Date
 
Date
Report Type
 
LOV Oracle
Organization Set
 
LOV Oracle