APPS.OKL_REP_PVT dependencies on FND_LOOKUPS

Line 637: FROM FND_LOOKUPS

633:
634: -- cursor to validate report category code
635: CURSOR c_is_valid_rpt_categ_code(p_rpt_categ_code OKL_REPORTS_B.REPORT_CATEGORY_CODE%TYPE) IS
636: SELECT 1
637: FROM FND_LOOKUPS
638: WHERE LOOKUP_TYPE = 'OKL_REPORT_CATEGORIES'
639: AND LOOKUP_CODE = p_rpt_categ_code;
640:
641: -- cursor to validate report type code

Line 644: FROM FND_LOOKUPS

640:
641: -- cursor to validate report type code
642: CURSOR c_is_valid_rpt_type_code(p_rpt_type_code OKL_REPORTS_B.REPORT_TYPE_CODE%TYPE) IS
643: SELECT 1
644: FROM FND_LOOKUPS
645: WHERE LOOKUP_TYPE = 'OKL_REPORT_TYPES'
646: AND LOOKUP_CODE = p_rpt_type_code;
647:
648: -- cursor to validate report status code

Line 651: FROM FND_LOOKUPS

647:
648: -- cursor to validate report status code
649: CURSOR c_is_valid_rpt_status_code(p_rpt_status_code OKL_REPORTS_B.STATUS_CODE%TYPE) IS
650: SELECT 1
651: FROM FND_LOOKUPS
652: WHERE LOOKUP_TYPE = 'OKL_RECON_REPORT_STATUSES'
653: AND LOOKUP_CODE = p_rpt_status_code;
654:
655: BEGIN