DBA Data[Home] [Help]

APPS.PAY_CA_RL1_AMEND_MAG dependencies on HR_LOCATIONS

Line 158: l_address_line1 hr_locations.address_line_1%TYPE;

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

Line 931: l_address_line hr_locations.address_line_1%TYPE;

927: lALangue NUMBER;
928: lNoConcepteur NUMBER;
929:
930: EOL VARCHAR2(5);
931: l_address_line hr_locations.address_line_1%TYPE;
932: l_contact VARCHAR2(60);
933: l_transmitter_name VARCHAR2(100);
934: l_context1 ff_archive_items.context1%TYPE;
935: l_taxation_year VARCHAR2(4);

Line 3221: l_address_line hr_locations.address_line_1%TYPE;

3217: l_context1 ff_archive_items.context1%TYPE;
3218: EOL varchar2(5);
3219: l_employer_name varchar2(100);
3220: l_quebec_bn varchar2(20);
3221: l_address_line hr_locations.address_line_1%TYPE;
3222: l_address_begin_tag varchar2(10);
3223: l_address_end_tag varchar2(10);
3224:
3225:

Line 3624: l_address_line hr_locations.address_line_1%TYPE;

3620: FROM pay_assignment_actions paa
3621: WHERE paa.assignment_action_id = p_assact_id;
3622: l_final_xml_string VARCHAR2(32000);
3623: l_index NUMBER;
3624: l_address_line hr_locations.address_line_1%TYPE;
3625: TYPE employer_info IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
3626:
3627: tab_employer employer_info;
3628: lNoId NUMBER;