DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1269: from hr_all_organization_units hou, hr_locations hl

1265: if pa_pay_util.g_location_code is null and l_organization_flag = 'Y' then
1266: begin
1267: select hl.location_code
1268: into pa_pay_util.g_location_code
1269: from hr_all_organization_units hou, hr_locations hl
1270: where hou.location_id = hl.location_id
1271: and hou.organization_id = l_asgn_rec.organization_id;
1272:
1273: l_stage := 'RBC for BnF: Named Person Flag: ' || l_named_person_flag ||', Organization Flag: ' || l_organization_flag ||', Organization Location code: ' || pa_pay_util.g_location_code;

Line 1302: from hr_all_organization_units hou, hr_locations hl

1298: if pa_pay_util.g_location_code is null and l_organization_flag = 'Y' then
1299: begin
1300: select hl.location_code
1301: into pa_pay_util.g_location_code
1302: from hr_all_organization_units hou, hr_locations hl
1303: where hou.location_id = hl.location_id
1304: and hou.organization_id = l_asgn_rec.organization_id;
1305:
1306: l_stage := 'RBC for BnF: Organization Flag: ' || l_organization_flag ||', Organization Location Code: ' || pa_pay_util.g_location_code;