APPS.AS_FOUNDATION_PVT dependencies on HR_LOOKUPS

Line 416: -- G_HR_LOOKUPS VARCHAR2 := 'HR_LOOKUPS',

412: -- Notes: The valid inputs for p_tablename are:
413: -- G_AS_LOOKUPS VARCHAR2 := 'AS_LOOKUPS',
414: -- G_AR_LOOKUPS VARCHAR2 := 'AR_LOOKUPS',
415: -- G_SO_LOOKUPS VARCHAR2 := 'SO_LOOKUPS',
416: -- G_HR_LOOKUPS VARCHAR2 := 'HR_LOOKUPS',
417: -- G_FND_COMMON_LOOKUPS VARCHAR2 := 'FND_COMMON_LOOKUPS',
418: -- G_CS_LOOKUPS VARCHAR2 := 'CS_LOOKUPS'
419:
420: FUNCTION get_lookupMeaning

Line 447: cursor hr_lookups_meaning_csr(l_lookup_type VARCHAR2,

443: from aso_lookups
444: where lookup_code = l_lookup_code
445: and lookup_type = l_lookup_type;
446: */
447: cursor hr_lookups_meaning_csr(l_lookup_type VARCHAR2,
448: l_lookup_code VARCHAR2) is
449: select meaning
450: from hr_lookups
451: where lookup_code = l_lookup_code

Line 450: from hr_lookups

446: */
447: cursor hr_lookups_meaning_csr(l_lookup_type VARCHAR2,
448: l_lookup_code VARCHAR2) is
449: select meaning
450: from hr_lookups
451: where lookup_code = l_lookup_code
452: and lookup_type = l_lookup_type;
453:
454: cursor cs_lookups_meaning_csr(l_lookup_type VARCHAR2,

Line 490: elsif p_tablename = G_HR_LOOKUPS

486: fetch so_lookups_meaning_csr into l_meaning;
487: close so_lookups_meaning_csr;
488: return l_meaning;
489: */
490: elsif p_tablename = G_HR_LOOKUPS
491: then
492: open hr_lookups_meaning_csr(p_lookup_type, p_lookup_code);
493: fetch hr_lookups_meaning_csr into l_meaning;
494: close hr_lookups_meaning_csr;

Line 492: open hr_lookups_meaning_csr(p_lookup_type, p_lookup_code);

488: return l_meaning;
489: */
490: elsif p_tablename = G_HR_LOOKUPS
491: then
492: open hr_lookups_meaning_csr(p_lookup_type, p_lookup_code);
493: fetch hr_lookups_meaning_csr into l_meaning;
494: close hr_lookups_meaning_csr;
495: return l_meaning;
496: elsif p_tablename = G_CS_LOOKUPS

Line 493: fetch hr_lookups_meaning_csr into l_meaning;

489: */
490: elsif p_tablename = G_HR_LOOKUPS
491: then
492: open hr_lookups_meaning_csr(p_lookup_type, p_lookup_code);
493: fetch hr_lookups_meaning_csr into l_meaning;
494: close hr_lookups_meaning_csr;
495: return l_meaning;
496: elsif p_tablename = G_CS_LOOKUPS
497: then

Line 494: close hr_lookups_meaning_csr;

490: elsif p_tablename = G_HR_LOOKUPS
491: then
492: open hr_lookups_meaning_csr(p_lookup_type, p_lookup_code);
493: fetch hr_lookups_meaning_csr into l_meaning;
494: close hr_lookups_meaning_csr;
495: return l_meaning;
496: elsif p_tablename = G_CS_LOOKUPS
497: then
498: open cs_lookups_meaning_csr(p_lookup_type, p_lookup_code);