DBA Data[Home] [Help]

APPS.PAY_CA_RL2_CAN_MAG dependencies on PER_ADDRESSES

Line 93: l_address_line1 per_addresses.address_line1%TYPE;

89: dummy1 VARCHAR2(10);
90: l_transmitter_org_id NUMBER;
91: l_arch_pactid NUMBER;
92: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
93: l_address_line1 per_addresses.address_line1%TYPE;
94:
95: l_locked_report_type pay_payroll_actions.report_type%TYPE;
96: l_mag_pactid NUMBER;
97:

Line 1561: l_address_line1 per_addresses.address_line1%TYPE;

1557: lBoxC_ExcessAmtSinPayTrans NUMBER;
1558: lCode_dereleve NUMBER;
1559:
1560: l_person_id per_people_f.person_id%TYPE;
1561: l_address_line1 per_addresses.address_line1%TYPE;
1562: l_address_line2 per_addresses.address_line2%TYPE;
1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;

Line 1562: l_address_line2 per_addresses.address_line2%TYPE;

1558: lCode_dereleve NUMBER;
1559:
1560: l_person_id per_people_f.person_id%TYPE;
1561: l_address_line1 per_addresses.address_line1%TYPE;
1562: l_address_line2 per_addresses.address_line2%TYPE;
1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;
1566: l_country VARCHAR2(60);

Line 1563: l_address_line3 per_addresses.address_line3%TYPE;

1559:
1560: l_person_id per_people_f.person_id%TYPE;
1561: l_address_line1 per_addresses.address_line1%TYPE;
1562: l_address_line2 per_addresses.address_line2%TYPE;
1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;
1566: l_country VARCHAR2(60);
1567: l_emp_province per_addresses.region_1%TYPE;

Line 1564: l_city per_addresses.town_or_city%TYPE;

1560: l_person_id per_people_f.person_id%TYPE;
1561: l_address_line1 per_addresses.address_line1%TYPE;
1562: l_address_line2 per_addresses.address_line2%TYPE;
1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;
1566: l_country VARCHAR2(60);
1567: l_emp_province per_addresses.region_1%TYPE;
1568: EOL VARCHAR2(5);

Line 1565: l_postal_code per_addresses.postal_code%TYPE;

1561: l_address_line1 per_addresses.address_line1%TYPE;
1562: l_address_line2 per_addresses.address_line2%TYPE;
1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;
1566: l_country VARCHAR2(60);
1567: l_emp_province per_addresses.region_1%TYPE;
1568: EOL VARCHAR2(5);
1569: l_taxation_year VARCHAR2(5);

Line 1567: l_emp_province per_addresses.region_1%TYPE;

1563: l_address_line3 per_addresses.address_line3%TYPE;
1564: l_city per_addresses.town_or_city%TYPE;
1565: l_postal_code per_addresses.postal_code%TYPE;
1566: l_country VARCHAR2(60);
1567: l_emp_province per_addresses.region_1%TYPE;
1568: EOL VARCHAR2(5);
1569: l_taxation_year VARCHAR2(5);
1570: l_name VARCHAR2(60);
1571: l_return VARCHAR2(30);

Line 2712: l_address_line per_addresses.address_line1%TYPE;

2708: l_legislative_param pay_payroll_actions.legislative_parameters%type;
2709: EOL varchar2(5);
2710: l_employer_name varchar2(100);
2711: l_quebec_bn varchar2(20);
2712: l_address_line per_addresses.address_line1%TYPE;
2713: l_address_begin_tag varchar2(10);
2714: l_address_end_tag varchar2(10);
2715:
2716: BEGIN