DBA Data[Home] [Help]

APPS.PAY_NL_RULES dependencies on PAY_ALL_PAYROLLS_F

Line 141: ,pay_all_payrolls_f pap

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
145: AND paa.effective_end_date >= p_effective_start_date

Line 169: pay_all_payrolls_f pap

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
173: and p_effective_date between pap.effective_start_date and pap.effective_end_date;