APPS.PER_FR_ELECTION dependencies on HR_ORGANIZATION_INFORMATION

Line 105: From hr_organization_information

101: VOTING_PLACE_LOG number;
102: --
103: Cursor get_reporting_establishment is
104: Select ORG_INFORMATION2 SIRET
105: From hr_organization_information
106: Where organization_id = p_reporting_est_id
107: and org_information_context = 'FR_ESTAB_INFO';
108: --
109: Cursor get_establishments is

Line 124: From hr_organization_information est

120: , rpad(nvl(substr(LOC.REGION_2,1,INSEE_CODE_LEN),' '),INSEE_CODE_LEN,' ') INSEE_CODE
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)