eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ORG_DLS_PKG dependencies on PSP_SCHEDULES

Line 96: First, need to check if the assignments from the selected organizations exist in the PSP_SCHEDULES table.

92:
93:
94:
95: /*******************************************************************************************************
96: First, need to check if the assignments from the selected organizations exist in the PSP_SCHEDULES table.
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

Line 283: PSP_SCHEDULES b,

279: d.SCHEDULE_END_DATE SCHEDULE_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

Line 466: PSP_SCHEDULES b,

462: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
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

Line 735: PSP_SCHEDULES b,

731: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
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

Line 1177: PSP_SCHEDULES b,

1173: select DISTINCT 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

Line 1197: PSP_SCHEDULES b,

1193: select DISTINCT 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

Line 1318: PSP_SCHEDULES b,

1314: c.ELEMENT_GROUP_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