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 580: FROM psp_schedule_hierarchy psh,

576: p_set_of_books_id IN NUMBER) IS
577:
578: CURSOR sch_hier_cur(v_organization_id NUMBER) IS
579: SELECT distinct psh.schedule_hierarchy_id
580: FROM psp_schedule_hierarchy psh,
581: psp_schedule_lines psl,
582: per_assignments_f paf
583: WHERE psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
584: AND paf.assignment_id = psh.assignment_id

Line 637: FROM psp_schedule_hierarchy psh,

633: /* Changes for bug 2863953 */
634:
635: Cursor c_all_org is
636: SELECT distinct paf.organization_id
637: FROM psp_schedule_hierarchy psh,
638: psp_schedule_lines psl,
639: per_assignments_f paf
640: WHERE psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
641: AND paf.assignment_id = psh.assignment_id

Line 1379: FROM psp_schedule_hierarchy

1375:
1376:
1377: CURSOR sch_hier_cur IS
1378: SELECT schedule_hierarchy_id
1379: FROM psp_schedule_hierarchy
1380: WHERE assignment_id = p_assignment_id;
1381:
1382: l_schedule_hierarchy_id NUMBER ( 15 );
1383: l_invalid_count NUMBER DEFAULT 0;