DBA Data[Home] [Help]

APPS.PER_PGN_BUS dependencies on HR_LOCATIONS_ALL

Line 608: from hr_locations_all loc

604: and hoi.org_information1 = 'PAR_ENT';
605: --
606: cursor csr_loc_exists is
607: select 'Y'
608: from hr_locations_all loc
609: where loc.location_id = p_entity_id;
610: --
611: cursor csr_loc_extra_exists is
612: select 'Y'

Line 613: from hr_locations_all loc,

609: where loc.location_id = p_entity_id;
610: --
611: cursor csr_loc_extra_exists is
612: select 'Y'
613: from hr_locations_all loc,
614: hr_location_extra_info lei
615: where loc.location_id = p_entity_id
616: and loc.location_id = lei.location_id
617: and lei.information_type in ('Establishment Information',