APPS.PER_US_VETS_100A_LIST_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 90: hr_location_extra_info hlei1

86: ltrim(rtrim(eloc.region_1))||', '||
87: ltrim(rtrim(eloc.region_2))||' '||
88: ltrim(rtrim(eloc.postal_code))) "Estab Address"
89: from
90: hr_location_extra_info hlei1
91: ,hr_location_extra_info hlei2
92: ,per_gen_hierarchy_nodes pghn
93: ,hr_locations_all eloc
94: where

Line 91: ,hr_location_extra_info hlei2

87: ltrim(rtrim(eloc.region_2))||' '||
88: ltrim(rtrim(eloc.postal_code))) "Estab Address"
89: from
90: hr_location_extra_info hlei1
91: ,hr_location_extra_info hlei2
92: ,per_gen_hierarchy_nodes pghn
93: ,hr_locations_all eloc
94: where
95: (hlei1.information_type = 'VETS-100 Specific Information'

Line 116: l_Est_Rep_Name hr_location_extra_info.lei_information1%type;

112: l_est_no number;
113:
114: l_reporting_name hr_organization_information.org_information1%type;
115: l_Est_Node_Id per_gen_hierarchy_nodes.hierarchy_node_id%type;
116: l_Est_Rep_Name hr_location_extra_info.lei_information1%type;
117: l_Headquarters hr_location_extra_info.lei_information10%type;
118: l_est_add clob;
119: l_report_date varchar2(11);
120:

Line 117: l_Headquarters hr_location_extra_info.lei_information10%type;

113:
114: l_reporting_name hr_organization_information.org_information1%type;
115: l_Est_Node_Id per_gen_hierarchy_nodes.hierarchy_node_id%type;
116: l_Est_Rep_Name hr_location_extra_info.lei_information1%type;
117: l_Headquarters hr_location_extra_info.lei_information10%type;
118: l_est_add clob;
119: l_report_date varchar2(11);
120:
121: l_xml_string clob :='';