DBA Data[Home] [Help]

APPS.PQP_GAP_BUS dependencies on PQP_GAP_ABSENCE_PLANS

Line 32: from pqp_gap_absence_plans gap

28: --
29: cursor csr_sec_grp is
30: select pbg.security_group_id,
31: pbg.legislation_code
32: from pqp_gap_absence_plans gap
33: , per_all_assignments_f paa
34: , per_business_groups_perf pbg
35: where gap.gap_absence_plan_id = p_gap_absence_plan_id
36: and paa.assignment_id = gap.assignment_id

Line 177: from pqp_gap_absence_plans gap

173: -- Declare cursor
174: --
175: cursor csr_leg_code is
176: select pbg.legislation_code
177: from pqp_gap_absence_plans gap
178: , per_all_assignments_f paa
179: , per_business_groups_perf pbg
180: where gap.gap_absence_plan_id = p_gap_absence_plan_id
181: and paa.assignment_id = gap.assignment_id