APPS.HR_HK_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 51: FROM per_business_groups pbg,

47: c_leg_code CONSTANT VARCHAR2(2) := 'HK';
48: --
49: CURSOR legsel IS
50: SELECT pbg.legislation_code
51: FROM per_business_groups pbg,
52: per_assignments_f asg
53: WHERE pbg.business_group_id = asg.business_group_id
54: AND asg.assignment_id = p_assignment_id
55: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 150: FROM per_business_groups pbg,

146: c_leg_code CONSTANT VARCHAR2(2) := 'HK';
147: --
148: CURSOR legsel IS
149: SELECT pbg.legislation_code
150: FROM per_business_groups pbg,
151: pay_personal_payment_methods_f ppm
152: WHERE pbg.business_group_id = ppm.business_group_id
153: AND ppm.personal_payment_method_id = p_personal_payment_method_id
154: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;