APPS.HR_NZ_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 26: FROM per_business_groups pbg,

22: l_effective_date DATE;
23: --
24: CURSOR csr_legcode IS
25: SELECT pbg.legislation_code
26: FROM per_business_groups pbg,
27: per_assignments_f asg
28: WHERE pbg.business_group_id = asg.business_group_id
29: AND asg.assignment_id = p_assignment_id
30: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 96: FROM per_business_groups pbg,

92: l_valid VARCHAR2(150);
93: --
94: CURSOR csr_legcode is
95: SELECT pbg.legislation_code
96: FROM per_business_groups pbg,
97: pay_personal_payment_methods_f ppm
98: WHERE pbg.business_group_id = ppm.business_group_id
99: AND ppm.personal_payment_method_id = p_personal_payment_method_id
100: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;