[Home] [Help]
97: If they do not, then, we need to add these assignments to the report to be displayed.
98: This is pretty straight-forward. If they do, then, we need to proceed to the next step.
99: *******************************************************************************************************/
100: -- First, obtain the Start and End Dates for assignments not existing in
101: -- PSP_SCHEDULE_HIERARCHY=> Time Period Begin and End Dates
102: /* For bug
103: Select Start_Date, End_Date
104: into l_Time_Period_Start_Date, l_Time_Period_End_Date
105: from PER_TIME_PERIODS
153: pay_payrolls_f where gl_set_of_books_id = '|| p_set_of_books_id || ')
154: and ( :p_end_date between a.EFFECTIVE_START_DATE
155: and a.EFFECTIVE_END_DATE)
156: and Not(Exists(Select ''X''
157: from PSP_SCHEDULE_HIERARCHY SCHI
158: ,PSP_SCHEDULE_LINES SCHL
159: where SCHI.Assignment_ID = a.ASSIGNMENT_ID
160: and SCHI.SCHEDULE_HIERARCHY_ID = SCHL.SCHEDULE_HIERARCHY_ID
161: and ((SCHL.SCHEDULE_BEGIN_DATE between :p_start_date and :p_end_date )
280: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
281: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
282: from PER_ASSIGNMENTS_F a,
283: PSP_SCHEDULES b,
284: PSP_SCHEDULE_HIERARCHY c,
285: PSP_SCHEDULE_LINES d,
286: PSP_DEFAULT_LABOR_SCHEDULES f
287: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
288: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID
463: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
464: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
465: from PER_ASSIGNMENTS_F a,
466: PSP_SCHEDULES b,
467: PSP_SCHEDULE_HIERARCHY c,
468: PSP_SCHEDULE_LINES d,
469: PSP_GROUP_ELEMENT_LIST f,
470: PSP_DEFAULT_LABOR_SCHEDULES g
471: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
732: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
733: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
734: from PER_ASSIGNMENTS_F a,
735: PSP_SCHEDULES b,
736: PSP_SCHEDULE_HIERARCHY c,
737: PSP_SCHEDULE_LINES d,
738: PSP_DEFAULT_LABOR_SCHEDULES f
739: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
740: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID
1174: d.SCHEDULE_BEGIN_DATE,
1175: d.SCHEDULE_END_DATE
1176: from PER_ASSIGNMENTS_F a,
1177: PSP_SCHEDULES b,
1178: PSP_SCHEDULE_HIERARCHY c,
1179: PSP_SCHEDULE_LINES d,
1180: PSP_GROUP_ELEMENT_LIST e
1181: where a.assignment_id = b.assignment_id
1182: and b.assignment_id = c.assignment_id
1194: d.SCHEDULE_BEGIN_DATE,
1195: d.SCHEDULE_END_DATE
1196: from PER_ASSIGNMENTS_F a,
1197: PSP_SCHEDULES b,
1198: PSP_SCHEDULE_HIERARCHY c,
1199: PSP_SCHEDULE_LINES d
1200: where a.assignment_id = b.assignment_id
1201: and b.assignment_id = c.assignment_id
1202: and c.schedule_hierarchy_id = d.schedule_hierarchy_id
1315: d.SCHEDULE_BEGIN_DATE,
1316: d.SCHEDULE_END_DATE
1317: from PER_ASSIGNMENTS_F a,
1318: PSP_SCHEDULES b,
1319: PSP_SCHEDULE_HIERARCHY c,
1320: PSP_SCHEDULE_LINES d,
1321: PSP_GROUP_ELEMENT_LIST e
1322: where a.assignment_id = b.assignment_id
1323: and b.assignment_id = c.assignment_id