APPS.PAY_CA_RL1_MAG dependencies on HR_LOOKUPS

Line 1231: hr_lookups

1227: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1228: SELECT
1229: meaning
1230: FROM
1231: hr_lookups
1232: WHERE
1233: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1234: lookup_code = p_lookup_code;
1235:

Line 1236: l_meaning hr_lookups.meaning%TYPE;

1232: WHERE
1233: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1234: lookup_code = p_lookup_code;
1235:
1236: l_meaning hr_lookups.meaning%TYPE;
1237: l_msg_code VARCHAR2(30);
1238: l_all_box_0 BOOLEAN;
1239: l_format_mask VARCHAR2(30);
1240: l_sequence_number NUMBER(9);

Line 4418: from hr_lookups

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

Line 4425: from HR_LOOKUPS HL,

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

Line 4438: , hr_lookups hl

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
4440: and hl.lookup_type = 'PAY_CA_RL1_NONBOX_FOOTNOTES'
4441: and hl.lookup_code = pai.action_information4
4442: );