APPS.PAY_CA_RL1_AMEND_MAG dependencies on HR_LOOKUPS

Line 1606: hr_lookups

1602: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1603: SELECT
1604: meaning
1605: FROM
1606: hr_lookups
1607: WHERE
1608: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1609: lookup_code = p_lookup_code;
1610:

Line 1614: FROM hr_lookups

1610:
1611: /* Cursor for fetching authorisation code */
1612: CURSOR c_get_auth_code(p_reporting_year varchar2) IS
1613: SELECT meaning
1614: FROM hr_lookups
1615: WHERE trim(lookup_code) = p_reporting_year
1616: AND lookup_type = 'PAY_CA_RL1_PDF_AUTH'
1617: AND enabled_flag='Y';
1618:

Line 1619: l_meaning hr_lookups.meaning%TYPE;

1615: WHERE trim(lookup_code) = p_reporting_year
1616: AND lookup_type = 'PAY_CA_RL1_PDF_AUTH'
1617: AND enabled_flag='Y';
1618:
1619: l_meaning hr_lookups.meaning%TYPE;
1620: l_msg_code VARCHAR2(30);
1621: l_all_box_0 BOOLEAN;
1622: l_format_mask VARCHAR2(30);
1623: l_sequence_number NUMBER(9);

Line 3478: from hr_lookups

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

Line 3485: from HR_LOOKUPS HL,

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

Line 3498: , hr_lookups hl

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
3500: and hl.lookup_type = 'PAY_CA_RL1_NONBOX_FOOTNOTES'
3501: and hl.lookup_code = pai.action_information4
3502: );