APPS.INVPVDR4 dependencies on OKS_COVERAGE_TEMPLTS_V

Line 43: WHERE TABLE_NAME = 'OKS_COVERAGE_TEMPLTS_V'

39:
40: CURSOR c_check_oks_template IS
41: SELECT 'Y'
42: FROM USER_TAB_COLUMNS
43: WHERE TABLE_NAME = 'OKS_COVERAGE_TEMPLTS_V'
44: AND COLUMN_NAME = 'ITEM_TYPE';
45:
46: -- Added the cursor for bug # 3762750
47: CURSOR c_mfglookup_exists(cp_lookup_type VARCHAR2,

Line 639: 'FROM OKS_COVERAGE_TEMPLTS_V '||

635: IF l_oks_exits = 'Y' THEN
636: EXECUTE IMMEDIATE
637: 'BEGIN '||
638: 'SELECT ''x'' INTO :temp '||
639: 'FROM OKS_COVERAGE_TEMPLTS_V '||
640: 'WHERE ITEM_TYPE = :cr.CONTRACT_ITEM_TYPE_CODE '||
641: 'AND ID = :cr.COVERAGE_SCHEDULE_ID '||
642: 'AND SYSDATE BETWEEN NVL(start_date, SYSDATE-1) AND NVL(end_date, SYSDATE+1); '||
643: 'END;'

Line 647: FROM OKS_COVERAGE_TEMPLTS_V

643: 'END;'
644: USING OUT temp, IN cr.CONTRACT_ITEM_TYPE_CODE, IN cr.COVERAGE_SCHEDULE_ID;
645: ELSE
646: SELECT 'x' INTO temp
647: FROM OKS_COVERAGE_TEMPLTS_V
648: WHERE ID = cr.COVERAGE_SCHEDULE_ID
649: AND SYSDATE BETWEEN NVL(start_date, SYSDATE-1) AND NVL(end_date, SYSDATE+1);
650: END IF;
651: EXCEPTION