1199:
1200: addr pay_us_get_item_data_pkg.person_name_address;
1201:
1202: l_employee_address VARCHAR2(300);
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1200: addr pay_us_get_item_data_pkg.person_name_address;
1201:
1202: l_employee_address VARCHAR2(300);
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1201:
1202: l_employee_address VARCHAR2(300);
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1202: l_employee_address VARCHAR2(300);
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1212: l_country_name varchar2(240);
1205: l_address_line3 per_addresses.address_line3%TYPE;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1212: l_country_name varchar2(240);
1213: l_person_id per_people_f.person_id%type;
1206: l_town_or_city per_addresses.town_or_city%TYPE;
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1212: l_country_name varchar2(240);
1213: l_person_id per_people_f.person_id%type;
1214: l_validate varchar2(1) := 'Y';
1207: l_province_or_state per_addresses.region_1%TYPE;
1208: l_region_1 per_addresses.region_1%TYPE;
1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1212: l_country_name varchar2(240);
1213: l_person_id per_people_f.person_id%type;
1214: l_validate varchar2(1) := 'Y';
1215:
1451: l_un_net_er number;
1452: l_ee_anuity number;
1453: l_tot_ee_contr number;
1454: l_ee_distribution_code varchar2(50);
1455: l_addr_line1 per_addresses.address_line1%TYPE;
1456: l_addr_line2 per_addresses.address_line2%TYPE;
1457: l_city_state_zip varchar2(100);
1458: l_eff_date date;
1459: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1452: l_ee_anuity number;
1453: l_tot_ee_contr number;
1454: l_ee_distribution_code varchar2(50);
1455: l_addr_line1 per_addresses.address_line1%TYPE;
1456: l_addr_line2 per_addresses.address_line2%TYPE;
1457: l_city_state_zip varchar2(100);
1458: l_eff_date date;
1459: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1460: l_st_tax_unit_id number;