DBA Data[Home] [Help]

APPS.PER_FR_ELECTION dependencies on HR_LOCATIONS

Line 126: , hr_locations loc

122: , rpad(nvl(substr(LOC.POSTAL_CODE,1,POSTAL_CODE_LEN),' '),POSTAL_CODE_LEN,' ') POSTAL_CODE
123: , rpad(nvl(substr(LOC.TOWN_OR_CITY,1,CITY_LEN),' '),CITY_LEN,' ') CITY
124: From hr_organization_information est
125: , hr_all_organization_units org
126: , hr_locations loc
127: Where ((p_establishment_id is not null
128: And est.organization_id = p_establishment_id)
129: Or (p_establishment_id is null
130: And to_number(org_information1) = p_company_id))