APPS.OKL_LRT_PVT dependencies on FND_LOOKUPS

Line 444: FROM fnd_lookups

440: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_arrears_yn';
441:
442: CURSOR c_yes_no IS
443: SELECT 'x'
444: FROM fnd_lookups
445: WHERE lookup_type = 'OKL_YES_NO' AND lookup_code = p_arrears_yn;
446: l_dummy varchar2(1);
447:
448: BEGIN

Line 496: FROM fnd_lookups

492: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_frq_code';
493:
494: CURSOR c_frq_code IS
495: SELECT 'x'
496: FROM fnd_lookups
497: WHERE lookup_type = 'OKL_FREQUENCY' AND lookup_code = p_frq_code;
498: l_dummy varchar2(1);
499:
500: BEGIN

Line 583: FROM fnd_lookups

579: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_lrs_type_code';
580:
581: CURSOR c_type_code IS
582: SELECT 'x'
583: FROM fnd_lookups
584: WHERE lookup_type = 'OKL_LRS_TYPES' AND lookup_code = p_type_code;
585: l_dummy varchar2(1) := '?';
586:
587: BEGIN

Line 635: FROM fnd_lookups

631: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_STS_CODE';
632:
633: CURSOR c_sts_code IS
634: SELECT 'x'
635: FROM fnd_lookups
636: WHERE lookup_type = 'OKL_PRC_STATUS' AND lookup_code = p_sts_code;
637: l_dummy varchar2(1);
638:
639: BEGIN