APPS.PAY_CA_RL1_MAG dependencies on HR_LOCATIONS

Line 155: l_address_line1 hr_locations.address_line_1%TYPE;

151: dummy1 VARCHAR2(10);
152: l_transmitter_org_id NUMBER;
153: l_arch_pactid NUMBER;
154: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
155: l_address_line1 hr_locations.address_line_1%TYPE;
156:
157: CURSOR cur_ppa IS
158: SELECT
159: ppa.legislative_parameters

Line 670: l_address_line hr_locations.address_line_1%TYPE;

666: lALangue NUMBER;
667: lNoConcepteur NUMBER;
668:
669: EOL VARCHAR2(5);
670: l_address_line hr_locations.address_line_1%TYPE;
671: l_contact VARCHAR2(60);
672: l_transmitter_name VARCHAR2(100);
673: l_context1 ff_archive_items.context1%TYPE;
674: l_taxation_year VARCHAR2(4);

Line 4162: l_address_line hr_locations.address_line_1%TYPE;

4158: l_context1 ff_archive_items.context1%TYPE;
4159: EOL varchar2(5);
4160: l_employer_name varchar2(100);
4161: l_quebec_bn varchar2(20);
4162: l_address_line hr_locations.address_line_1%TYPE;
4163: l_address_begin_tag varchar2(10);
4164: l_address_end_tag varchar2(10);
4165:
4166: BEGIN

Line 4565: l_address_line hr_locations.address_line_1%TYPE;

4561: FROM pay_assignment_actions paa
4562: WHERE paa.assignment_action_id = p_assact_id;
4563: l_final_xml_string VARCHAR2(32000);
4564: l_index NUMBER;
4565: l_address_line hr_locations.address_line_1%TYPE;
4566: TYPE employer_info IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
4567:
4568: tab_employer employer_info;
4569: lNoId NUMBER;