DBA Data[Home] [Help]

APPS.HR_SG_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 71: FROM per_business_groups pbg,

67: c_leg_code CONSTANT VARCHAR2(2) := 'SG';
68: --
69: CURSOR legsel IS
70: SELECT pbg.legislation_code
71: FROM per_business_groups pbg,
72: per_assignments_f asg
73: WHERE pbg.business_group_id = asg.business_group_id
74: AND asg.assignment_id = p_assignment_id
75: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 170: FROM per_business_groups pbg,

166: c_leg_code CONSTANT VARCHAR2(2) := 'SG';
167: --
168: CURSOR legsel IS
169: SELECT pbg.legislation_code
170: FROM per_business_groups pbg,
171: pay_personal_payment_methods_f ppm
172: WHERE pbg.business_group_id = ppm.business_group_id
173: AND ppm.personal_payment_method_id = p_personal_payment_method_id
174: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;