APPS.OKE_DELIVERABLE_PVT dependencies on OKC_K_LINES_B

Line 96: FROM okc_k_lines_b

92: L_Value VARCHAR2(1) := 'N';
93:
94: CURSOR C (P_ID NUMBER) IS
95: SELECT 'X'
96: FROM okc_k_lines_b
97: WHERE ID = P_ID
98: AND NOT EXISTS(SELECT 'X' FROM okc_ancestrys
99: WHERE Cle_ID_Ascendant = P_ID);
100:

Line 600: FROM okc_k_lines_b

596: L_Value VARCHAR2(1) := 'N';
597:
598: CURSOR C IS
599: SELECT 'X'
600: FROM okc_k_lines_b
601: WHERE P_DEL_REC.Delivery_Date >= NVL(P_DEL_REC.Start_Date, P_DEL_REC.Delivery_Date)
602: AND P_DEL_REC.Delivery_Date <= NVL(P_DEL_REC.End_Date, P_DEL_REC.Delivery_Date)
603: AND P_DEL_REC.Delivery_Date >= NVL(Start_Date, P_DEL_REC.Delivery_Date)
604: AND P_DEL_REC.Delivery_Date <= NVL(End_Date, P_DEL_REC.Delivery_Date)

Line 1140: FROM okc_k_lines_b

1136: L_End_Date DATE;
1137:
1138: CURSOR C ( P_ID NUMBER ) IS
1139: SELECT Start_Date, End_Date
1140: FROM okc_k_lines_b
1141: WHERE ID = P_ID;
1142:
1143:
1144: Begin

Line 1199: FROM okc_k_lines_b

1195: L_End_Date DATE;
1196:
1197: CURSOR C ( P_ID NUMBER ) IS
1198: SELECT Start_Date, End_Date
1199: FROM okc_k_lines_b
1200: WHERE ID = P_ID;
1201:
1202:
1203: Begin

Line 1256: FROM okc_k_lines_b

1252: L_End_Date DATE;
1253:
1254: CURSOR C ( P_ID NUMBER ) IS
1255: SELECT Start_Date, End_Date
1256: FROM okc_k_lines_b
1257: WHERE ID = P_ID;
1258:
1259:
1260: Begin