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 3786: from per_establishments pe

3782: l_object_version_number number;
3783: begin
3784: select pe.object_version_number
3785: into l_object_version_number
3786: from per_establishments pe
3787: where pe.location = p_location
3788: and pe.name = p_establishment_name;
3789: return l_object_version_number;
3790: exception