APPS.PAY_NL_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: from per_all_assignments_f paa

82:
83: cursor c_bg_id(p_ee_id in number)
84: is
85: select distinct paa.business_group_id
86: from per_all_assignments_f paa
87: ,pay_element_entries_f pee
88: where pee.element_entry_id=p_ee_id
89: and pee.assignment_id=paa.assignment_id;
90:

Line 140: FROM per_all_assignments_f paa

136: SELECT DECODE(pay_nl_rules.get_object_group_type
137: ,'EMPLOYER'
138: ,prl_information1
139: ,substr(pap.payroll_name,1,30))
140: FROM per_all_assignments_f paa
141: ,pay_all_payrolls_f pap
142: WHERE paa.assignment_id = p_assignment_id
143: AND paa.payroll_id = pap.payroll_id
144: AND paa.effective_start_date <= p_effective_end_date

Line 168: per_all_assignments_f asg,

164: p_tax_unit_id IN OUT NOCOPY NUMBER) IS
165: --
166: CURSOR cur_tax_unit_id IS
167: select NVL(asg.establishment_id,prl_information1) from
168: per_all_assignments_f asg,
169: pay_all_payrolls_f pap
170: where assignment_id = p_assignment_id
171: and asg.payroll_id = pap.payroll_id
172: and p_effective_date between asg.effective_start_date and asg.effective_end_date