APPS.PAY_PYCAROEP_XMLP_PKG dependencies on HR_LOOKUPS

Line 18: from hr_lookups

14: where person_id=p_person_id;
15:
16: CURSOR csr_get_sel_type(p_selection_type varchar2) is
17: select meaning
18: from hr_lookups
19: where lookup_type = 'PAY_CA_ROE_SELECTION_TYPE'
20: and lookup_code = p_selection_type;
21:
22: l_person varchar2(320);

Line 144: meaning from hr_lookups

140: function cf_languageformula(ROE_PER_CORRESPONDENCE_LANG1 in varchar2, ROE_FINAL_PAY_PERIOD_END_DATE in varchar2) return char is
141: l_language varchar2(25);
142:
143: cursor cur_lookup is select
144: meaning from hr_lookups
145: where lookup_type = 'PAY_CA_CORRESPONDENCE_LANGUAGE'
146: and lookup_code = ROE_PER_CORRESPONDENCE_LANG1;
147: begin
148: open cur_lookup;