APPS.PAY_CA_RL1_AMEND_MAG dependencies on PAY_CA_RL1_REG

Line 1403: addr pay_ca_rl1_reg.primaryaddress;

1399: l_final_xml_string1 VARCHAR2(32000);
1400: l_final_xml_string2 VARCHAR2(32000);
1401: l_final_xml_string3 VARCHAR2(32000);
1402: k NUMBER;
1403: addr pay_ca_rl1_reg.primaryaddress;
1404: /********************** ************************/
1405: l_final_xml CLOB;
1406: l_final_xml_string VARCHAR2(32000);
1407: l_is_temp_final_xml VARCHAR2(2);

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

3473: ,p_arch_assactid NUMBER)is
3474: select substr(ltrim(rtrim(code)),1,60) code,to_char(value,'999,999.99') value
3475: from (
3476:
3477: select pay_ca_rl1_reg.get_label(lookup_type,lookup_code,p_person_lang) code, p_cpp_withheld value
3478: from hr_lookups
3479: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
3480: and lookup_code = 'CPP'
3481: and p_cpp_withheld <> 0

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

3479: where lookup_type = 'PAY_CA_RL1_FOOTNOTES'
3480: and lookup_code = 'CPP'
3481: and p_cpp_withheld <> 0
3482: union
3483: select SUBSTR(fdi.user_name,11,4)||', '||pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
3484: to_number(fai.value) value
3485: from HR_LOOKUPS HL,
3486: ff_database_items fdi,
3487: ff_archive_items fai

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

3491: and fai.value <> '0'
3492: and hl.lookup_type = 'PAY_CA_RL1_FOOTNOTES'
3493: AND HL.LOOKUP_CODE = SUBSTR(replace(FDI.USER_NAME,'_AMT_PER_JD_YTD'),-2)
3494: union all
3495: select pay_ca_rl1_reg.get_label(hl.lookup_type,hl.lookup_code,p_person_lang) code,
3496: to_number(pai.action_information5) value
3497: from pay_action_information pai
3498: , hr_lookups hl
3499: where pai.action_context_id = p_arch_assactid