APPS.PSP_ORG_DLS_PKG dependencies on PSP_SCHEDULE_LINES

Line 158: ,PSP_SCHEDULE_LINES SCHL

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 )
162: or (SCHL.SCHEDULE_END_DATE between :p_start_date and :p_end_date )

Line 285: PSP_SCHEDULE_LINES d,

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
289: and c.SCHEDULE_HIERARCHY_ID = d.SCHEDULE_HIERARCHY_ID

Line 468: PSP_SCHEDULE_LINES d,

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
472: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID

Line 737: PSP_SCHEDULE_LINES d,

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
741: and c.SCHEDULE_HIERARCHY_ID = d.SCHEDULE_HIERARCHY_ID

Line 1179: PSP_SCHEDULE_LINES d,

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
1183: and c.schedule_hierarchy_id = d.schedule_hierarchy_id

Line 1199: PSP_SCHEDULE_LINES d

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
1203: and a.assignment_id = l_Assignment_ID

Line 1320: PSP_SCHEDULE_LINES d,

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
1324: and c.schedule_hierarchy_id = d.schedule_hierarchy_id