[Home] [Help]
APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on HR_LOCATIONS_ALL
Line 179: hr_locations_all hla
175: ||decode(hla.region_3,Null,'',','||hla.region_3) --Small Town
176: ||decode(hla.town_or_city,Null,'',','||hla.town_or_city) --City
177: From
178: hr_all_organization_units haou ,
179: hr_locations_all hla
180: where haou.organization_id = c_organization_id
181: and haou.location_id = hla.location_id (+);
182:
183: l_pension_provider_id Number;