APPS.PA_PAY_VALIDATE dependencies on PA_PAY_EXTERNAL_PAYROLL

Line 18: l_payroll_id pa_pay_external_payroll.payroll_id%TYPE;

14: l_group_id hr_organization_units.business_group_id%TYPE;
15:
16: l_group_id2 hr_organization_units.business_group_id%TYPE;
17:
18: l_payroll_id pa_pay_external_payroll.payroll_id%TYPE;
19:
20: x_start_date Date;
21: x_end_date date;
22:

Line 71: select payroll_id into l_payroll_id from pa_pay_external_payroll

67: l_payroll_id := NULL;
68:
69: BEGIN
70:
71: select payroll_id into l_payroll_id from pa_pay_external_payroll
72: where payroll_name = Pay_rec.payroll_name;
73:
74: exception
75: when others then

Line 163: select payroll_id into l_payroll_id from pa_pay_external_payroll

159: --{
160:
161: begin
162:
163: select payroll_id into l_payroll_id from pa_pay_external_payroll
164: where payroll_name = Hdr_rec.payroll_name;
165:
166: exception
167: when others then

Line 178: and not exists (select null from pa_pay_external_payroll ppep

174:
175: Update pa_pay_ext_interface_header eih
176: set rejection_code = 'RC 155'
177: where interface_header_id = Hdr_rec.interface_header_id
178: and not exists (select null from pa_pay_external_payroll ppep
179: where ppep.business_group_id = nvl(Hdr_rec.business_group_id,l_group_id)
180: and ppep.payroll_id = nvl(eih.payroll_id,l_payroll_id)
181: and effective_start_date <= Hdr_rec.time_period_start_date
182: and nvl(effective_end_date,Hdr_rec.time_period_end_date+1) >= Hdr_rec.time_period_end_date