DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on OKC_K_ITEMS

Line 1085: FROM OKC_K_ITEMS KIT

1081:
1082: CURSOR okl_inst_csr (p_kle_id IN NUMBER) IS
1083: SELECT
1084: KIT.OBJECT1_ID1
1085: FROM OKC_K_ITEMS KIT
1086: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1087: KLB.ID = p_kle_id);
1088:
1089: l_tas_id NUMBER;

Line 1223: FROM OKC_K_ITEMS KIT

1219:
1220: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1221: SELECT
1222: KIT.OBJECT1_ID1
1223: FROM OKC_K_ITEMS KIT
1224: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1225: KLB.ID = p_kle_id);
1226:
1227: