APPS.PAY_CA_RL1_MAG dependencies on PAY_CA_RL1_REG

Line 1057: addr pay_ca_rl1_reg.primaryaddress;

1053: l_final_xml_string1 VARCHAR2(32000);
1054: l_final_xml_string2 VARCHAR2(32000);
1055: l_final_xml_string3 VARCHAR2(32000);
1056: k NUMBER;
1057: addr pay_ca_rl1_reg.primaryaddress;
1058: /********************** ************************/
1059: l_final_xml CLOB;
1060: l_final_xml_string VARCHAR2(32000);
1061: l_is_temp_final_xml VARCHAR2(2);

Line 1521: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);

1517:
1518: select trunc(sysdate) into l_session_date from dual;
1519: hr_utility.trace('l_person_id1 ='|| l_person_id1);
1520: hr_utility.trace('l_session_date ='|| l_session_date);
1521: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);
1522: tab_xml_employee(lLigne1) := convert_special_char(substr(addr.addr_line_1,1,40));
1523: tab_xml_employee(lLigne2) := convert_special_char(substr(addr.addr_line_2,1,40)||' '||substr(addr.addr_line_3,1,40));
1524: tab_xml_employee(lVille) := convert_special_char(substr(addr.addr_line_4,1,40));
1525: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(l_mag_asg_action_id, --l_arch_action_id,

Line 4417: select pay_ca_rl1_reg.get_label(lookup_type,lookup_code,p_person_lang) code, p_cpp_withheld value

4413: ,p_arch_assactid NUMBER)is
4414: select substr(ltrim(rtrim(code)),1,60) code,to_char(value,'999,999.99') value
4415: from (
4416:
4417: select pay_ca_rl1_reg.get_label(lookup_type,lookup_code,p_person_lang) code, p_cpp_withheld value
4418: from hr_lookups
4419: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4420: and lookup_code = 'CPP'
4421: and p_cpp_withheld <> 0

Line 4423: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,

4419: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4420: and lookup_code = 'CPP'
4421: and p_cpp_withheld <> 0
4422: union
4423: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4424: to_number(fai.value) value
4425: from HR_LOOKUPS HL,
4426: ff_database_items fdi,
4427: ff_archive_items fai

Line 4435: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,

4431: and fai.value <> '0'
4432: and hl.lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4433: AND HL.LOOKUP_CODE = SUBSTR(replace(FDI.USER_NAME,'_AMT_PER_JD_YTD'),-2)
4434: union all
4435: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4436: to_number(pai.action_information5) value
4437: from pay_action_information pai
4438: , hr_lookups hl
4439: where pai.action_context_id = p_arch_assactid