APPS.PAY_CA_RL1_MAG dependencies on HR_LOOKUPS

Line 1247: l_err_msg hr_lookups.meaning%TYPE;

1243: l_final_xml BLOB;
1244: l_temp_blob BLOB;
1245: l_header_xml_string VARCHAR2(32000);
1246: l_trailer_xml VARCHAR2(32000);
1247: l_err_msg hr_lookups.meaning%TYPE;
1248: EOL varchar2(10);
1249:
1250: CURSOR c_province( p_arch_asact_id number) is
1251: select fai.value

Line 1266: from hr_lookups

1262:
1263: /* To get error message */
1264: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1265: select meaning
1266: from hr_lookups
1267: where
1268: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1269: lookup_code = p_lookup_code;
1270:

Line 1775: hr_lookups

1771: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1772: SELECT
1773: meaning
1774: FROM
1775: hr_lookups
1776: WHERE
1777: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1778: lookup_code = p_lookup_code;
1779:

Line 1783: FROM hr_lookups

1779:
1780: /* Cursor for fetching authorisation code */
1781: CURSOR c_get_auth_code(p_reporting_year varchar2) IS
1782: SELECT meaning
1783: FROM hr_lookups
1784: WHERE trim(lookup_code) = p_reporting_year
1785: AND lookup_type = 'PAY_CA_RL1_PDF_AUTH'
1786: AND enabled_flag='Y';
1787:

Line 1788: l_meaning hr_lookups.meaning%TYPE;

1784: WHERE trim(lookup_code) = p_reporting_year
1785: AND lookup_type = 'PAY_CA_RL1_PDF_AUTH'
1786: AND enabled_flag='Y';
1787:
1788: l_meaning hr_lookups.meaning%TYPE;
1789: l_msg_code VARCHAR2(30);
1790: l_all_box_0 BOOLEAN;
1791: l_format_mask VARCHAR2(30);
1792: -- l_sequence_number NUMBER(9);

Line 4457: from hr_lookups

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
4461: union

Line 4464: from HR_LOOKUPS HL,

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
4467: where fai.user_entity_id=fdi.user_entity_id
4468: and fai.context1= p_arch_assactid

Line 4477: , hr_lookups hl

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
4479: and hl.lookup_type = 'PAY_CA_RL1_NONBOX_FOOTNOTES'
4480: and hl.lookup_code = pai.action_information4
4481: );