DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PER_ADDRESSES

Line 1203: l_address_line1 per_addresses.address_line1%TYPE;

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;

Line 1204: l_address_line2 per_addresses.address_line2%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;

Line 1205: l_address_line3 per_addresses.address_line3%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;

Line 1206: l_town_or_city per_addresses.town_or_city%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;

Line 1207: l_province_or_state per_addresses.region_1%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;

Line 1208: l_region_1 per_addresses.region_1%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);

Line 1209: l_region_2 per_addresses.region_2%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);
1213: l_person_id per_people_f.person_id%type;

Line 1210: l_postal_code per_addresses.postal_code%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';

Line 1211: l_country per_addresses.country%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';
1215:

Line 1455: l_addr_line1 per_addresses.address_line1%TYPE;

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;

Line 1456: l_addr_line2 per_addresses.address_line2%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;