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 640: 'FROM OKS_COVERAGE_TEMPLTS_V '||

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

Line 648: FROM OKS_COVERAGE_TEMPLTS_V

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