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;
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;
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;
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;
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;
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);
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;
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';
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:
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;
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;