DBA Data[Home] [Help]

APPS.HR_PL_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 94: from per_business_groups pbg,

90: l_valid varchar2(150);
91: --
92: cursor legsel is
93: select pbg.legislation_code
94: from per_business_groups pbg,
95: per_assignments_f asg
96: where pbg.business_group_id = asg.business_group_id
97: and asg.assignment_id = p_assignment_id
98: and p_effective_date between asg.effective_start_date

Line 283: from per_business_groups pbg,

279: l_valid varchar2(150);
280: --
281: cursor legsel is
282: select pbg.legislation_code
283: from per_business_groups pbg,
284: pay_personal_payment_methods_f ppm
285: where pbg.business_group_id = ppm.business_group_id
286: and ppm.personal_payment_method_id = p_personal_payment_method_id
287: and p_effective_date between ppm.effective_start_date