DBA Data[Home] [Help]

APPS.PQP_GDA_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 37: , per_all_assignments_f paa

33: select pbg.security_group_id,
34: pbg.legislation_code
35: from pqp_gap_daily_absences gda
36: , pqp_gap_absence_plans gap
37: , per_all_assignments_f paa
38: , per_business_groups_perf pbg
39: where gda.gap_daily_absence_id = p_gap_daily_absence_id
40: and gap.gap_absence_plan_id = gda.gap_absence_plan_id
41: and paa.assignment_id = gap.assignment_id

Line 113: , per_all_assignments_f paa

109: cursor csr_leg_code is
110: select pbg.legislation_code
111: from pqp_gap_daily_absences gda
112: , pqp_gap_absence_plans gap
113: , per_all_assignments_f paa
114: , per_business_groups_perf pbg
115: where gda.gap_daily_absence_id = p_gap_daily_absence_id
116: and gap.gap_absence_plan_id = gda.gap_absence_plan_id
117: and paa.assignment_id = gap.assignment_id