APPS.PAY_CA_T4A_XML dependencies on HR_LOOKUPS

Line 210: l_err_msg hr_lookups.meaning%TYPE;

206: EOL varchar2(10);
207: l_xml_version varchar2(100);
208: l_is_temp_final_xml VARCHAR2(2);
209: lv_negative_bal_flag VARCHAR2(5);
210: l_err_msg hr_lookups.meaning%TYPE;
211:
212: /* To get error message */
213: cursor cur_get_meaning(p_lookup_code VARCHAR2) IS
214: select

Line 217: hr_lookups

213: cursor cur_get_meaning(p_lookup_code VARCHAR2) IS
214: select
215: meaning
216: from
217: hr_lookups
218: where
219: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
220: lookup_code = p_lookup_code;
221:

Line 487: l_err_msg hr_lookups.meaning%TYPE;

483: l_date date;
484: i number := 0;
485: l_count number := 0;
486: l_msg_code varchar2(30);
487: l_err_msg hr_lookups.meaning%TYPE;
488: l_is_temp_final_xml VARCHAR2(2);
489:
490:
491: --array introduced by rgottipa for bug 6456662

Line 536: from hr_lookups HL,

532: SUBSTR(fdi.user_name,11,5)||': '||
533: SUBSTR(pay_ca_t4a_reg.get_label('PAY_CA_T4A_FOOTNOTES',
534: hl.lookup_code, l_lang),1,46)) code,
535: to_number(fai.value) value
536: from hr_lookups HL,
537: ff_database_items fdi,
538: ff_archive_items fai
539: where fai.user_entity_id=fdi.user_entity_id
540: and fai.context1= p_assignment_action_id

Line 553: hr_lookups hl

549: pay_ca_t4a_reg.get_label('PAY_CA_T4A_NONBOX_FOOTNOTES',
550: hl.lookup_code, l_lang)),
551: to_number(pai.action_information5)
552: from pay_action_information pai,
553: hr_lookups hl
554: where pai.action_context_id = p_assignment_action_id
555: and hl.lookup_type = 'PAY_CA_T4A_NONBOX_FOOTNOTES'
556: and hl.lookup_code = pai.action_information4
557: and pai.action_information6 = 'T4A')

Line 566: hr_lookups

562: cursor cur_get_meaning(p_lookup_code VARCHAR2) IS
563: select
564: meaning
565: from
566: hr_lookups
567: where
568: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
569: lookup_code = p_lookup_code;
570: