PSP Organization Level Default Labor Schedule

Select 	a.ORGANIZATION_ID,
        	a.ASSIGNMENT_ID,
        	a.PERSON_ID,
	a.ELEMENT_TYPE_ID,
	a.SCHEDULE_BEGIN_DATE,
	a.SCHEDULE_END_DATE,
	b.GL_CODE_COMBINATION_ID,
	b.PROJECT_ID,
	b.EXPENDITURE_ORGANIZATION_ID,
	b.EXPENDITURE_TYPE,
	b.TASK_ID,
	b.AWARD_ID,
	b.SCHEDULE_BEGIN_DATE DEFAULT_BEGIN_DATE,
	b.SCHEDULE_END_DATE DEFAULT_END_DATE,
	PSP_PSPLSODL_XMLP_PKG.cf_organization_nameformula(a.ORGANIZATION_ID) CF_ORGANIZATION_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_gl_accountformula(b.GL_CODE_COMBINATION_ID) CF_GL_ACCOUNT,
	PSP_PSPLSODL_XMLP_PKG.cf_project_nameformula(b.PROJECT_ID) CF_PROJECT_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_task_nameformula(b.TASK_ID, b.PROJECT_ID) CF_Task_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_award_nameformula(b.AWARD_ID) CF_Award_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_exp_org_nameformula(b.EXPENDITURE_ORGANIZATION_ID) CF_EXP_ORG_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_default_begin_dateformula(b.SCHEDULE_BEGIN_DATE, :CF_date_format) CF_default_begin_date,
	PSP_PSPLSODL_XMLP_PKG.cf_default_end_dateformula(b.SCHEDULE_END_DATE, :CF_date_format) CF_default_end_date,
	PSP_PSPLSODL_XMLP_PKG.cf_earnings_elementformula(a.ELEMENT_TYPE_ID) CF_EARNINGS_ELEMENT,
	PSP_PSPLSODL_XMLP_PKG.cf_employee_idformula(a.PERSON_ID) CF_EMPLOYEE_ID,
	PSP_PSPLSODL_XMLP_PKG.cf_person_nameformula(a.PERSON_ID) CF_Person_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_assignment_numberformula(a.ASSIGNMENT_ID, a.PERSON_ID) CF_Assignment_Number,
	PSP_PSPLSODL_XMLP_PKG.cf_schedule_begin_dateformula(a.SCHEDULE_BEGIN_DATE, :CF_date_format, a.SCHEDULE_END_DATE) CF_schedule_begin_date,
	PSP_PSPLSODL_XMLP_PKG.cf_schedule_end_dateformula(a.SCHEDULE_END_DATE, :CF_date_format) CF_schedule_end_date,
	PSP_PSPLSODL_XMLP_PKG.cf_number_working_daysformula(a.SCHEDULE_BEGIN_DATE, a.SCHEDULE_END_DATE) CF_NUMBER_WORKING_DAYS
from 	PSP_REP_ORG_DLS a,
	PSP_DEFAULT_LABOR_SCHEDULES b
where 	a.ORG_DLS_BATCH_ID = :P_BATCH_ID1
and	a.SCHEDULE_LINE_ID = b.ORG_SCHEDULE_ID
and b.business_group_id = :P_BUSINESS_GROUP_ID
and b.set_of_books_id = :P_SET_OF_BOOKS_ID
group by a.ORGANIZATION_ID,
	b.GL_CODE_COMBINATION_ID,
	b.PROJECT_ID,
	b.EXPENDITURE_ORGANIZATION_ID,
	b.EXPENDITURE_TYPE,
	b.TASK_ID,
	b.AWARD_ID,
	b.SCHEDULE_BEGIN_DATE,
	b.SCHEDULE_END_DATE,
	a.ELEMENT_TYPE_ID,
        	a.PERSON_ID,
        	a.ASSIGNMENT_ID,
	a.SCHEDULE_BEGIN_DATE,
	a.SCHEDULE_END_DATE
	order by 15, 16, 17, 18, 19, 20, 10, 13, 14, 23, 24, 25, 26, 27, 28, 29