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_MATRIX_DRIVER_PKG dependencies on PSP_SCHEDULE_HIERARCHY

Line 546: FROM psp_schedule_hierarchy psh,

542: p_set_of_books_id IN NUMBER) IS
543:
544: CURSOR sch_hier_cur(v_organization_id NUMBER) IS
545: SELECT distinct psh.schedule_hierarchy_id
546: FROM psp_schedule_hierarchy psh,
547: psp_schedule_lines psl,
548: per_assignments_f paf
549: WHERE psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
550: AND paf.assignment_id = psh.assignment_id

Line 603: FROM psp_schedule_hierarchy psh,

599: /* Changes for bug 2863953 */
600:
601: Cursor c_all_org is
602: SELECT distinct paf.organization_id
603: FROM psp_schedule_hierarchy psh,
604: psp_schedule_lines psl,
605: per_assignments_f paf
606: WHERE psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
607: AND paf.assignment_id = psh.assignment_id

Line 1345: FROM psp_schedule_hierarchy

1341:
1342:
1343: CURSOR sch_hier_cur IS
1344: SELECT schedule_hierarchy_id
1345: FROM psp_schedule_hierarchy
1346: WHERE assignment_id = p_assignment_id;
1347:
1348: l_schedule_hierarchy_id NUMBER ( 15 );
1349: l_invalid_count NUMBER DEFAULT 0;