APPS.OKS_OKSSUMCO_XMLP_PKG dependencies on OKC_K_LINES_B

Line 126: OKC_K_LINES_B

122: CURSOR C1(CN_CONTRACT_ID IN NUMBER,CV_STS_CODE IN VARCHAR2) IS
123: SELECT
124: SUM(PRICE_NEGOTIATED)
125: FROM
126: OKC_K_LINES_B
127: WHERE DNZ_CHR_ID = CN_CONTRACT_ID
128: AND LSE_ID IN ( 7 , 8 , 9 , 10 , 11 , 35 , 13 , 18 , 25 )
129: AND STS_CODE = CV_STS_CODE;
130: LN_CONTRACT_ID NUMBER;

Line 161: OKC_K_LINES_B

157: CURSOR C1(CN_CONTRACT_ID IN NUMBER,CV_STS_CODE IN VARCHAR2) IS
158: SELECT
159: SUM(PRICE_NEGOTIATED / (END_DATE - START_DATE + 1))
160: FROM
161: OKC_K_LINES_B
162: WHERE DNZ_CHR_ID = CN_CONTRACT_ID
163: AND LSE_ID IN ( 7 , 8 , 9 , 10 , 11 , 35 , 13 , 18 , 25 )
164: AND STS_CODE = CV_STS_CODE;
165: LN_CONTRACT_ID NUMBER;