DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER_PKG dependencies on PER_ASSIGNMENTS_F

Line 582: per_assignments_f paf

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
585: AND paf.organization_id = v_organization_id
586: AND psl.schedule_begin_date <= p_period_to

Line 639: per_assignments_f paf

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
642: AND psl.schedule_begin_date <= p_period_to
643: AND psl.schedule_end_date >= p_period_from