APPS.PAY_US_NACHA_IAT_TAPE dependencies on HR_LOCATIONS

Line 114: g_street_address hr_locations.ADDRESS_LINE_1%type;

110: g_payroll_id PAY_PAYROLLS_F.PAYROLL_ID%TYPE;
111: g_organization_id per_all_assignments.ORGANIZATION_ID%TYPE;
112: g_full_name per_all_people_f.full_name%type;
113: g_org_name hr_organization_units.name%type;
114: g_street_address hr_locations.ADDRESS_LINE_1%type;
115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;

Line 115: g_city hr_locations.TOWN_OR_CITY%type;

111: g_organization_id per_all_assignments.ORGANIZATION_ID%TYPE;
112: g_full_name per_all_people_f.full_name%type;
113: g_org_name hr_organization_units.name%type;
114: g_street_address hr_locations.ADDRESS_LINE_1%type;
115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;
119: g_postal_code hr_locations.POSTAL_CODE%type;

Line 116: g_state hr_locations.REGION_1%type;

112: g_full_name per_all_people_f.full_name%type;
113: g_org_name hr_organization_units.name%type;
114: g_street_address hr_locations.ADDRESS_LINE_1%type;
115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;
119: g_postal_code hr_locations.POSTAL_CODE%type;
120: g_emp_num per_all_people_f.employee_number%type := null;

Line 117: g_county hr_locations.REGION_2%type;

113: g_org_name hr_organization_units.name%type;
114: g_street_address hr_locations.ADDRESS_LINE_1%type;
115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;
119: g_postal_code hr_locations.POSTAL_CODE%type;
120: g_emp_num per_all_people_f.employee_number%type := null;
121: g_emp_adress per_addresses_v.ADDRESS_LINE1%type := null;

Line 118: g_country hr_locations.COUNTRY%type;

114: g_street_address hr_locations.ADDRESS_LINE_1%type;
115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;
119: g_postal_code hr_locations.POSTAL_CODE%type;
120: g_emp_num per_all_people_f.employee_number%type := null;
121: g_emp_adress per_addresses_v.ADDRESS_LINE1%type := null;
122: g_emp_city per_addresses_v.TOWN_OR_CITY%type := null;

Line 119: g_postal_code hr_locations.POSTAL_CODE%type;

115: g_city hr_locations.TOWN_OR_CITY%type;
116: g_state hr_locations.REGION_1%type;
117: g_county hr_locations.REGION_2%type;
118: g_country hr_locations.COUNTRY%type;
119: g_postal_code hr_locations.POSTAL_CODE%type;
120: g_emp_num per_all_people_f.employee_number%type := null;
121: g_emp_adress per_addresses_v.ADDRESS_LINE1%type := null;
122: g_emp_city per_addresses_v.TOWN_OR_CITY%type := null;
123: g_emp_state per_addresses_v.REGION_2%type := null;