eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL2_AMEND_MAG dependencies on PER_ADDRESSES

Line 173: l_address_line1 per_addresses.address_line1%TYPE;

169: dummy1 VARCHAR2(10);
170: l_transmitter_org_id NUMBER;
171: l_arch_pactid NUMBER;
172: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
173: l_address_line1 per_addresses.address_line1%TYPE;
174:
175: CURSOR cur_ppa IS
176: SELECT
177: ppa.legislative_parameters

Line 1550: l_address_line1 per_addresses.address_line1%TYPE;

1546: lBoxC_ExcessAmtSinPayTrans NUMBER;
1547: lCode_dereleve NUMBER;
1548:
1549: l_person_id per_people_f.person_id%TYPE;
1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;

Line 1551: l_address_line2 per_addresses.address_line2%TYPE;

1547: lCode_dereleve NUMBER;
1548:
1549: l_person_id per_people_f.person_id%TYPE;
1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;
1555: l_country VARCHAR2(60);

Line 1552: l_address_line3 per_addresses.address_line3%TYPE;

1548:
1549: l_person_id per_people_f.person_id%TYPE;
1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;
1555: l_country VARCHAR2(60);
1556: l_emp_province per_addresses.region_1%TYPE;

Line 1553: l_city per_addresses.town_or_city%TYPE;

1549: l_person_id per_people_f.person_id%TYPE;
1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;
1555: l_country VARCHAR2(60);
1556: l_emp_province per_addresses.region_1%TYPE;
1557: EOL VARCHAR2(5);

Line 1554: l_postal_code per_addresses.postal_code%TYPE;

1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;
1555: l_country VARCHAR2(60);
1556: l_emp_province per_addresses.region_1%TYPE;
1557: EOL VARCHAR2(5);
1558: l_taxation_year VARCHAR2(5);

Line 1556: l_emp_province per_addresses.region_1%TYPE;

1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;
1554: l_postal_code per_addresses.postal_code%TYPE;
1555: l_country VARCHAR2(60);
1556: l_emp_province per_addresses.region_1%TYPE;
1557: EOL VARCHAR2(5);
1558: l_taxation_year VARCHAR2(5);
1559: l_name VARCHAR2(60);
1560: l_return VARCHAR2(30);

Line 2867: l_address_line1 per_addresses.address_line1%TYPE;

2863: l_legislative_param pay_payroll_actions.legislative_parameters%type;
2864: EOL varchar2(5);
2865: l_employer_name varchar2(100);
2866: l_quebec_bn varchar2(20);
2867: l_address_line1 per_addresses.address_line1%TYPE;
2868: l_address_line2 per_addresses.address_line2%TYPE;
2869: l_city per_addresses.town_or_city%TYPE;
2870: l_province VARCHAR2(100);
2871: l_postal_code per_addresses.postal_code%TYPE;

Line 2868: l_address_line2 per_addresses.address_line2%TYPE;

2864: EOL varchar2(5);
2865: l_employer_name varchar2(100);
2866: l_quebec_bn varchar2(20);
2867: l_address_line1 per_addresses.address_line1%TYPE;
2868: l_address_line2 per_addresses.address_line2%TYPE;
2869: l_city per_addresses.town_or_city%TYPE;
2870: l_province VARCHAR2(100);
2871: l_postal_code per_addresses.postal_code%TYPE;
2872: l_address_begin_tag varchar2(10);

Line 2869: l_city per_addresses.town_or_city%TYPE;

2865: l_employer_name varchar2(100);
2866: l_quebec_bn varchar2(20);
2867: l_address_line1 per_addresses.address_line1%TYPE;
2868: l_address_line2 per_addresses.address_line2%TYPE;
2869: l_city per_addresses.town_or_city%TYPE;
2870: l_province VARCHAR2(100);
2871: l_postal_code per_addresses.postal_code%TYPE;
2872: l_address_begin_tag varchar2(10);
2873: l_address_end_tag varchar2(10);

Line 2871: l_postal_code per_addresses.postal_code%TYPE;

2867: l_address_line1 per_addresses.address_line1%TYPE;
2868: l_address_line2 per_addresses.address_line2%TYPE;
2869: l_city per_addresses.town_or_city%TYPE;
2870: l_province VARCHAR2(100);
2871: l_postal_code per_addresses.postal_code%TYPE;
2872: l_address_begin_tag varchar2(10);
2873: l_address_end_tag varchar2(10);
2874:
2875: CURSOR get_employer_info( p_business_group_id number,