DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER_PKG dependencies on PER_ASSIGNMENTS_F

Line 548: per_assignments_f paf

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

Line 605: per_assignments_f paf

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