APPS.HR_AU_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 75: FROM per_business_groups pbg,

71: c_leg_code CONSTANT VARCHAR2(2) := 'AU';
72: --
73: CURSOR legsel IS
74: SELECT pbg.legislation_code
75: FROM per_business_groups pbg,
76: per_assignments_f asg
77: WHERE pbg.business_group_id = asg.business_group_id
78: AND asg.assignment_id = p_assignment_id
79: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 174: FROM per_business_groups pbg,

170: c_leg_code CONSTANT VARCHAR2(2) := 'AU';
171: --
172: CURSOR legsel IS
173: SELECT pbg.legislation_code
174: FROM per_business_groups pbg,
175: pay_personal_payment_methods_f ppm
176: WHERE pbg.business_group_id = ppm.business_group_id
177: AND ppm.personal_payment_method_id = p_personal_payment_method_id
178: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;