APPS.PA_PAY_VALIDATE dependencies on HR_ORGANIZATION_UNITS

Line 14: l_group_id hr_organization_units.business_group_id%TYPE;

10: is
11: l_value_exists number;
12: l_request_id number(15);
13:
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;

Line 16: l_group_id2 hr_organization_units.business_group_id%TYPE;

12: l_request_id number(15);
13:
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;

Line 122: select business_group_id into l_group_id from hr_organization_units

118: IF(Hdr_rec.business_group_id is null) THEN
119: --{
120: begin
121:
122: select business_group_id into l_group_id from hr_organization_units
123: where name = Hdr_rec.business_group_name;
124:
125: exception
126: when others then

Line 138: and not exists (select null from hr_organization_units hou

134:
135: Update pa_pay_ext_interface_header eih
136: set rejection_code = 'RC 150'
137: where interface_header_id = Hdr_rec.interface_header_id
138: and not exists (select null from hr_organization_units hou
139: where hou.business_group_id = nvl(Hdr_rec.business_group_id,l_group_id)
140: and hou.business_group_id = nvl(eih.business_group_id,l_group_id));
141:
142: IF SQL%ROWCOUNT > 0 THEN