APPS.OKL_LRT_PVT dependencies on FND_LOOKUPS

Line 454: FROM fnd_lookups

450: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_arrears_yn';
451:
452: CURSOR c_yes_no IS
453: SELECT 'x'
454: FROM fnd_lookups
455: WHERE lookup_type = 'OKL_YES_NO' AND lookup_code = p_arrears_yn;
456: l_dummy varchar2(1);
457:
458: BEGIN

Line 506: FROM fnd_lookups

502: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_frq_code';
503:
504: CURSOR c_frq_code IS
505: SELECT 'x'
506: FROM fnd_lookups
507: WHERE lookup_type = 'OKL_FREQUENCY' AND lookup_code = p_frq_code;
508: l_dummy varchar2(1);
509:
510: BEGIN

Line 593: FROM fnd_lookups

589: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_lrs_type_code';
590:
591: CURSOR c_type_code IS
592: SELECT 'x'
593: FROM fnd_lookups
594: WHERE lookup_type = 'OKL_LRS_TYPES' AND lookup_code = p_type_code;
595: l_dummy varchar2(1) := '?';
596:
597: BEGIN

Line 645: FROM fnd_lookups

641: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_STS_CODE';
642:
643: CURSOR c_sts_code IS
644: SELECT 'x'
645: FROM fnd_lookups
646: WHERE lookup_type = 'OKL_PRC_STATUS' AND lookup_code = p_sts_code;
647: l_dummy varchar2(1);
648:
649: BEGIN