DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on PER_ADDRESSES_V

Line 121: g_emp_adress per_addresses_v.ADDRESS_LINE1%type := null;

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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;

Line 122: g_emp_city per_addresses_v.TOWN_OR_CITY%type := null;

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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;
126: g_emp_postal per_addresses_v.POSTAL_CODE%type := null;

Line 123: g_emp_state per_addresses_v.REGION_2%type := null;

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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;
126: g_emp_postal per_addresses_v.POSTAL_CODE%type := null;
127: g_first_exec VARCHAR2(1) := 'Y';

Line 124: g_emp_county per_addresses_v.REGION_1%type := null;

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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;
126: g_emp_postal per_addresses_v.POSTAL_CODE%type := null;
127: g_first_exec VARCHAR2(1) := 'Y';
128: g_org_addenda VARCHAR2(1) := 'N';

Line 125: g_emp_country per_addresses_v.D_COUNTRY%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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;
126: g_emp_postal per_addresses_v.POSTAL_CODE%type := null;
127: g_first_exec VARCHAR2(1) := 'Y';
128: g_org_addenda VARCHAR2(1) := 'N';
129:

Line 126: g_emp_postal per_addresses_v.POSTAL_CODE%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;
124: g_emp_county per_addresses_v.REGION_1%type := null;
125: g_emp_country per_addresses_v.D_COUNTRY%type := null;
126: g_emp_postal per_addresses_v.POSTAL_CODE%type := null;
127: g_first_exec VARCHAR2(1) := 'Y';
128: g_org_addenda VARCHAR2(1) := 'N';
129:
130: