DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ESTABLISHMENTS

Line 115: from per_establishments pe

111: l_establishment_id number;
112: begin
113: select pe.establishment_id
114: into l_establishment_id
115: from per_establishments pe
116: where pe.location = p_location
117: and pe.name = p_establishment_name;
118: return l_establishment_id;
119: exception

Line 3813: from per_establishments pe

3809: l_object_version_number number;
3810: begin
3811: select pe.object_version_number
3812: into l_object_version_number
3813: from per_establishments pe
3814: where pe.location = p_location
3815: and pe.name = p_establishment_name;
3816: return l_object_version_number;
3817: exception