DBA Data[Home] [Help]

APPS.HR_FR_PERS_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 66: from per_business_groups pbg,

62: -- Declare cursors and local variables
63: --
64: cursor legsel is
65: select pbg.legislation_code
66: from per_business_groups pbg,
67: per_assignments_f asg
68: where pbg.business_group_id = asg.business_group_id
69: and asg.assignment_id = p_assignment_id
70: and p_effective_date between asg.effective_start_date

Line 220: from per_business_groups pbg,

216: l_valid varchar2(150);
217: --
218: cursor legsel is
219: select pbg.legislation_code
220: from per_business_groups pbg,
221: pay_personal_payment_methods_f ppm
222: where pbg.business_group_id = ppm.business_group_id
223: and ppm.personal_payment_method_id = p_personal_payment_method_id
224: and p_effective_date between ppm.effective_start_date