APPS.HR_IN_PERSONAL_PAY_METHOD_API dependencies on PER_BUSINESS_GROUPS

Line 68: FROM per_business_groups pbg,

64: l_effective_date DATE;
65:
66: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
67: SELECT pbg.legislation_code
68: FROM per_business_groups pbg,
69: per_assignments_f asg
70: WHERE pbg.business_group_id = asg.business_group_id
71: AND asg.assignment_id = p_assignment_id
72: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;

Line 74: l_legislation_code per_business_groups.legislation_code%type;

70: WHERE pbg.business_group_id = asg.business_group_id
71: AND asg.assignment_id = p_assignment_id
72: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
73:
74: l_legislation_code per_business_groups.legislation_code%type;
75: --
76: --
77: BEGIN
78: l_proc := g_package||'create_in_personal_pay_method';

Line 219: FROM per_business_groups pbg,

215: l_effective_date DATE;
216:
217: CURSOR legsel IS
218: SELECT pbg.legislation_code
219: FROM per_business_groups pbg,
220: pay_personal_payment_methods_f ppm
221: WHERE pbg.business_group_id = ppm.business_group_id
222: AND ppm.personal_payment_method_id = p_personal_payment_method_id
223: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;

Line 225: l_legislation_code per_business_groups.legislation_code%type;

221: WHERE pbg.business_group_id = ppm.business_group_id
222: AND ppm.personal_payment_method_id = p_personal_payment_method_id
223: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;
224: --
225: l_legislation_code per_business_groups.legislation_code%type;
226: --
227: BEGIN
228: l_proc := g_package||'update_in_personal_pay_method';
229: pay_in_utils.set_location(g_debug,'Entering:'|| l_proc, 10);