APPS.PAY_CA_RL1_MAG dependencies on PAY_CA_RL1_REG

Line 1597: addr pay_ca_rl1_reg.primaryaddress;

1593: lv_montants_string VARCHAR2(32000);
1594: lv_NomFamille_Ligne_string VARCHAR2(2000);
1595:
1596: k NUMBER;
1597: addr pay_ca_rl1_reg.primaryaddress;
1598: /********************** ************************/
1599: l_final_xml CLOB;
1600: l_temp_blob BLOB;
1601: l_is_temp_final_xml VARCHAR2(2);

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

2077:
2078: select trunc(sysdate) into l_session_date from dual;
2079: hr_utility.trace('l_person_id1 ='|| l_person_id1);
2080: hr_utility.trace('l_session_date ='|| l_session_date);
2081: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);
2082: tab_xml_employee(lLigne1) := convert_special_char(substr(addr.addr_line_1,1,40));
2083: tab_xml_employee(lLigne2) := convert_special_char(substr(addr.addr_line_2,1,40)||' '||substr(addr.addr_line_3,1,40));
2084: tab_xml_employee(lVille) := convert_special_char(substr(addr.addr_line_4,1,40));
2085: tab_xml_employee(lForm_number) := pay_ca_archive_utils.get_archive_value(p_arch_action_id, --l_mag_asg_action_id

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

4452: ,p_arch_assactid NUMBER)is
4453: select substr(ltrim(rtrim(code)),1,60) code,to_char(value,'999,999.99') value
4454: from (
4455:
4456: select pay_ca_rl1_reg.get_label(lookup_type,lookup_code,p_person_lang) code, p_cpp_withheld value
4457: from hr_lookups
4458: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4459: and lookup_code = 'CPP'
4460: and p_cpp_withheld <> 0

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

4458: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4459: and lookup_code = 'CPP'
4460: and p_cpp_withheld <> 0
4461: union
4462: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4463: to_number(fai.value) value
4464: from HR_LOOKUPS HL,
4465: ff_database_items fdi,
4466: ff_archive_items fai

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

4470: and fai.value <> '0'
4471: and hl.lookup_type = 'PAY_CA_RL1_FOOTNOTES'
4472: AND HL.LOOKUP_CODE = SUBSTR(replace(FDI.USER_NAME,'_AMT_PER_JD_YTD'),-2)
4473: union all
4474: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
4475: to_number(pai.action_information5) value
4476: from pay_action_information pai
4477: , hr_lookups hl
4478: where pai.action_context_id = p_arch_assactid