DBA Data[Home] [Help]

APPS.PER_FR_ELECTION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 125: , hr_all_organization_units org

121: , rpad(nvl(substr(LOC.REGION_3,1,TOWN_LEN),' '),TOWN_LEN,' ') TOWN
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