APPS.PA_COST1 dependencies on PER_ALL_ASSIGNMENTS_F

Line 1199: from hr_locations a, per_all_assignments_f b

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);

Line 1283: from hr_locations a, per_all_assignments_f b

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);