[Home] [Help]
446: is
447: l_description varchar2(150);
448: begin
449: /*Bug No. 3237648*/
450: /*Fetching from hr_lookups instead of fnd_lookup_values*/
451: select description into l_description
452: from hr_lookups hlu
453: where hlu.lookup_type = p_lookup_type
454: and hlu.lookup_code = p_lookup_code
448: begin
449: /*Bug No. 3237648*/
450: /*Fetching from hr_lookups instead of fnd_lookup_values*/
451: select description into l_description
452: from hr_lookups hlu
453: where hlu.lookup_type = p_lookup_type
454: and hlu.lookup_code = p_lookup_code
455: and hlu.ENABLED_FLAG = 'Y'
456: and fnd_date.canonical_to_date(p_effective_date) between
1809: p_effective_date date) return varchar2
1810: is
1811: l_meaning varchar2(100);
1812: /*Bug No. 3237648*/
1813: /*Fetching from hr_lookups instead of fnd_lookup_values*/
1814: cursor csr_meaning is
1815: select meaning
1816: from hr_lookups hlu
1817: where hlu.lookup_type = p_lookup_type
1812: /*Bug No. 3237648*/
1813: /*Fetching from hr_lookups instead of fnd_lookup_values*/
1814: cursor csr_meaning is
1815: select meaning
1816: from hr_lookups hlu
1817: where hlu.lookup_type = p_lookup_type
1818: and hlu.lookup_code = p_lookup_code
1819: and hlu.enabled_flag='Y'
1820: and p_effective_date between
5575: --
5576: cursor csr_lookup(p_code Varchar2)
5577: is
5578: select hlu.meaning hlu_meaning
5579: from hr_lookups hlu
5580: where hlu.lookup_type='GB_COUNTY'
5581: and hlu.lookup_code=p_code
5582: and hlu.enabled_flag='Y';
5583:
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;
5594: l_meaning hr_lookups.meaning%type;
5595: begin
5596: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);
5597: dbms_lob.open(l_xfdf_str,dbms_lob.lob_readwrite);
5598: open csr_address_entries;