APPS.PQP_GAP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 33: , per_all_assignments_f paa

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
37: and pbg.business_group_id = paa.business_group_id;

Line 104: from per_all_assignments_f paa

100: -- Declare cursor
101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_all_assignments_f paa
105: , per_business_groups_perf pbg
106: where paa.assignment_id = p_assignment_id
107: and pbg.business_group_id = paa.business_group_id;
108: --

Line 178: , per_all_assignments_f paa

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
182: and pbg.business_group_id = paa.business_group_id;