[Home] [Help]
1195: end if;
1196:
1197: select location_code
1198: into pa_pay_util.g_location_code
1199: from hr_locations a, per_all_assignments_f b
1200: where b.person_id = p_person_id
1201: and a.location_use = 'HR'
1202: and a.location_id = b.location_id
1203: and p_exp_item_date between b.effective_start_date and nvl(b.effective_end_date, p_exp_item_date);
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;
1279: elsif pa_pay_util.g_location_code is null and l_organization_flag = 'N' then
1280: begin
1281: select a.location_code
1282: into pa_pay_util.g_location_code
1283: from hr_locations a, per_all_assignments_f b
1284: where b.person_id = p_person_id
1285: and a.location_use = 'HR'
1286: and a.location_id = b.location_id
1287: and p_exp_item_date between b.effective_start_date and nvl(b.effective_end_date, p_exp_item_date);
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;