APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_STATUSES_V

Line 525: FROM OKC_STATUSES_V

521: IS
522:
523: CURSOR c_get_status_type IS
524: SELECT STE_CODE
525: FROM OKC_STATUSES_V
526: WHERE CODE = P_LINE_STS_CODE;
527:
528: L_STATUS VARCHAR2(240);
529: BEGIN

Line 2440: FROM OKC_STATUSES_V

2436: l_sts_code VARCHAR2(30);
2437:
2438: Cursor l_sts_csr Is
2439: SELECT CODE
2440: FROM OKC_STATUSES_V
2441: WHERE STE_CODE = 'ENTERED'
2442: AND DEFAULT_YN = 'Y'
2443: AND sysdate BETWEEN START_DATE AND nvl(END_DATE,sysdate);
2444: