APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 56: from per_business_groups pbg,

52: l_effective_date date;
53: --
54: cursor legsel is
55: select pbg.legislation_code
56: from per_business_groups pbg,
57: per_assignments_f asg
58: where pbg.business_group_id = asg.business_group_id
59: and asg.assignment_id = p_assignment_id
60: and p_effective_date between asg.effective_start_date

Line 168: from per_business_groups pbg,

164: l_valid varchar2(150);
165: --
166: cursor legsel is
167: select pbg.legislation_code
168: from per_business_groups pbg,
169: pay_personal_payment_methods_f ppm
170: where pbg.business_group_id = ppm.business_group_id
171: and ppm.personal_payment_method_id = p_personal_payment_method_id
172: and p_effective_date between ppm.effective_start_date

Line 683: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.

679: where pa.assignment_id = p_assignment_id
680: and p_effective_date between pa.effective_start_date
681: and pa.effective_end_date;
682: --
683: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
684: cursor csr_is_valid is
685: select null
686: from pay_org_payment_methods_f opm,
687: pay_payment_types ppt