DBA Data[Home] [Help]

APPS.PERFRPHR dependencies on HR_LOCATIONS_ALL

Line 314: hr_locations_all loc,

310: --
311: FROM per_addresses adr,
312: per_contracts_f con,
313: per_jobs job,
314: hr_locations_all loc,
315: hr_ALL_ORGANIZATION_UNITS OU1,
316: HR_ORGANIZATION_INFORMATION OI1,
317: per_assignment_extra_info ext,
318: per_all_assignments_f ass,

Line 420: hr_locations_all loc,

416: --
417: FROM per_addresses adr,
418: per_contracts_f con,
419: per_jobs job,
420: hr_locations_all loc,
421: hr_ALL_ORGANIZATION_UNITS OU1,
422: HR_ORGANIZATION_INFORMATION OI1,
423: per_assignment_extra_info ext,
424: per_all_assignments_f ass,

Line 453: FROM hr_locations_all

449: postal_code,
450: town_or_city,
451: telephone_number_1,
452: telephone_number_2
453: FROM hr_locations_all
454: WHERE location_id = corres_loc_id;
455: --
456: r_app c_app%ROWTYPE;
457: -- Added for bug #5240132