APPS.PAY_CA_RL1_MAG dependencies on HR_LOCATIONS

Line 303: l_address_line1 hr_locations.address_line_1%TYPE;

299: dummy1 VARCHAR2(10);
300: l_transmitter_org_id NUMBER;
301: l_arch_pactid NUMBER;
302: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
303: l_address_line1 hr_locations.address_line_1%TYPE;
304:
305: CURSOR cur_ppa IS
306: SELECT
307: ppa.legislative_parameters

Line 868: l_address_line hr_locations.address_line_1%TYPE;

864: lALangue NUMBER;
865: lNoConcepteur NUMBER;
866:
867: EOL VARCHAR2(5);
868: l_address_line hr_locations.address_line_1%TYPE;
869: l_contact VARCHAR2(60);
870: l_transmitter_name VARCHAR2(100);
871: l_context1 ff_archive_items.context1%TYPE;
872: l_taxation_year VARCHAR2(4);

Line 4199: l_address_line hr_locations.address_line_1%TYPE;

4195: l_context1 ff_archive_items.context1%TYPE;
4196: EOL varchar2(5);
4197: l_employer_name varchar2(100);
4198: l_quebec_bn varchar2(20);
4199: l_address_line hr_locations.address_line_1%TYPE;
4200: l_address_begin_tag varchar2(10);
4201: l_address_end_tag varchar2(10);
4202:
4203: BEGIN

Line 4617: l_address_line hr_locations.address_line_1%TYPE;

4613: WHERE paa.assignment_action_id = p_assact_id;
4614:
4615: l_final_xml_string VARCHAR2(32000);
4616: l_index NUMBER;
4617: l_address_line hr_locations.address_line_1%TYPE;
4618: TYPE employer_info IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
4619:
4620: tab_employer employer_info;
4621: lNoId NUMBER;