DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PER_ADDRESSES

Line 1187: l_address_line1 per_addresses.address_line1%TYPE;

1183:
1184: addr pay_us_get_item_data_pkg.person_name_address;
1185:
1186: l_employee_address VARCHAR2(300);
1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;

Line 1188: l_address_line2 per_addresses.address_line2%TYPE;

1184: addr pay_us_get_item_data_pkg.person_name_address;
1185:
1186: l_employee_address VARCHAR2(300);
1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;

Line 1189: l_address_line3 per_addresses.address_line3%TYPE;

1185:
1186: l_employee_address VARCHAR2(300);
1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;

Line 1190: l_town_or_city per_addresses.town_or_city%TYPE;

1186: l_employee_address VARCHAR2(300);
1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;

Line 1191: l_province_or_state per_addresses.region_1%TYPE;

1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;

Line 1192: l_region_1 per_addresses.region_1%TYPE;

1188: l_address_line2 per_addresses.address_line2%TYPE;
1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;
1196: l_country_name varchar2(240);

Line 1193: l_region_2 per_addresses.region_2%TYPE;

1189: l_address_line3 per_addresses.address_line3%TYPE;
1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;
1196: l_country_name varchar2(240);
1197: l_person_id per_people_f.person_id%type;

Line 1194: l_postal_code per_addresses.postal_code%TYPE;

1190: l_town_or_city per_addresses.town_or_city%TYPE;
1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;
1196: l_country_name varchar2(240);
1197: l_person_id per_people_f.person_id%type;
1198: l_validate varchar2(1) := 'Y';

Line 1195: l_country per_addresses.country%TYPE;

1191: l_province_or_state per_addresses.region_1%TYPE;
1192: l_region_1 per_addresses.region_1%TYPE;
1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;
1196: l_country_name varchar2(240);
1197: l_person_id per_people_f.person_id%type;
1198: l_validate varchar2(1) := 'Y';
1199:

Line 1437: l_addr_line1 per_addresses.address_line1%TYPE;

1433: l_un_net_er number;
1434: l_ee_anuity number;
1435: l_tot_ee_contr number;
1436: l_ee_distribution_code varchar2(50);
1437: l_addr_line1 per_addresses.address_line1%TYPE;
1438: l_addr_line2 per_addresses.address_line2%TYPE;
1439: l_city_state_zip varchar2(100);
1440: l_eff_date date;
1441: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;

Line 1438: l_addr_line2 per_addresses.address_line2%TYPE;

1434: l_ee_anuity number;
1435: l_tot_ee_contr number;
1436: l_ee_distribution_code varchar2(50);
1437: l_addr_line1 per_addresses.address_line1%TYPE;
1438: l_addr_line2 per_addresses.address_line2%TYPE;
1439: l_city_state_zip varchar2(100);
1440: l_eff_date date;
1441: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1442: l_st_tax_unit_id number;