APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on HR_LOOKUPS

Line 458: /*Fetching from hr_lookups instead of fnd_lookup_values*/

454: is
455: l_description varchar2(150);
456: begin
457: /*Bug No. 3237648*/
458: /*Fetching from hr_lookups instead of fnd_lookup_values*/
459: select description into l_description
460: from hr_lookups hlu
461: where hlu.lookup_type = p_lookup_type
462: and hlu.lookup_code = p_lookup_code

Line 460: from hr_lookups hlu

456: begin
457: /*Bug No. 3237648*/
458: /*Fetching from hr_lookups instead of fnd_lookup_values*/
459: select description into l_description
460: from hr_lookups hlu
461: where hlu.lookup_type = p_lookup_type
462: and hlu.lookup_code = p_lookup_code
463: and hlu.ENABLED_FLAG = 'Y'
464: and fnd_date.canonical_to_date(p_effective_date) between

Line 2265: /*Fetching from hr_lookups instead of fnd_lookup_values*/

2261: p_effective_date date) return varchar2
2262: is
2263: l_meaning varchar2(100);
2264: /*Bug No. 3237648*/
2265: /*Fetching from hr_lookups instead of fnd_lookup_values*/
2266: cursor csr_meaning is
2267: select meaning
2268: from hr_lookups hlu
2269: where hlu.lookup_type = p_lookup_type

Line 2268: from hr_lookups hlu

2264: /*Bug No. 3237648*/
2265: /*Fetching from hr_lookups instead of fnd_lookup_values*/
2266: cursor csr_meaning is
2267: select meaning
2268: from hr_lookups hlu
2269: where hlu.lookup_type = p_lookup_type
2270: and hlu.lookup_code = p_lookup_code
2271: and hlu.enabled_flag='Y'
2272: and p_effective_date between

Line 6399: from hr_lookups hlu

6395: --
6396: cursor csr_lookup(p_code Varchar2)
6397: is
6398: select hlu.meaning hlu_meaning
6399: from hr_lookups hlu
6400: where hlu.lookup_type='GB_COUNTY'
6401: and hlu.lookup_code=p_code
6402: and hlu.enabled_flag='Y';
6403:

Line 6408: from hr_lookups

6404: --Cursor Added for bug 8942337
6405: cursor csr_get_priv_mark
6406: is
6407: select meaning
6408: from hr_lookups
6409: where lookup_type='GB_P11D_PRI_MARKINGS'
6410: and lookup_code=p_priv_mark
6411: and enabled_flag='Y';
6412:

Line 6425: l_meaning hr_lookups.meaning%type;

6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09
6423: l_fore_name varchar2(150); -- P11D 08/09
6424: l_code pay_action_information.action_information9%type;
6425: l_meaning hr_lookups.meaning%type;
6426: --Parameter Added for bug 8942337
6427: l_priv_mark_meaning hr_lookups.meaning%type;
6428:
6429: begin

Line 6427: l_priv_mark_meaning hr_lookups.meaning%type;

6423: l_fore_name varchar2(150); -- P11D 08/09
6424: l_code pay_action_information.action_information9%type;
6425: l_meaning hr_lookups.meaning%type;
6426: --Parameter Added for bug 8942337
6427: l_priv_mark_meaning hr_lookups.meaning%type;
6428:
6429: begin
6430:
6431: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);