DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_CA_RL1_REG

Line 281: address pay_ca_rl1_reg.primaryaddress;

277: lv_employee_province varchar2(200);
278: lv_employee_country varchar2(200);
279: lv_employee_postal_code varchar2(10);
280: lv_employee_address varchar2(10000);
281: address pay_ca_rl1_reg.primaryaddress;
282: lv_person_id number;
283:
284: lv_cpp_qpp_exempt varchar2(10);
285: lv_ei_exempt varchar2(10);

Line 467: address := pay_ca_rl1_reg.get_primary_address(lv_person_id, sysdate());

463:
464: lv_person_id := to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,
465: 'CAEOY_PERSON_ID'));
466:
467: address := pay_ca_rl1_reg.get_primary_address(lv_person_id, sysdate());
468:
469: lv_employee_address1 := substr(address.addr_line_1,1,44);
470: lv_employee_address2 := substr(address.addr_line_2,1,44);
471: lv_employee_address3 := substr(address.addr_line_3,1,44);