APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on HR_ALL_ORGANIZATION_UNITS

Line 155: hr_all_organization_units haou,

151: union
152: Select
153: decode(hoi.org_information3,'N','Z',hoi.org_information3) flag ,hoi.org_information1
154: From
155: hr_all_organization_units haou,
156: hr_organization_information hoi
157: Where haou.organization_id = c_establishment_id
158: and haou.organization_id = hoi.organization_id
159: and hoi.org_information_context = 'FR_ESTAB_PE_PRVS'

Line 178: hr_all_organization_units haou ,

174: ||decode(hla.address_line_2,Null,'',','||hla.address_line_2) --Complement
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: