DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on OKC_K_ITEMS

Line 1171: FROM OKC_K_ITEMS KIT

1167:
1168: CURSOR okl_inst_csr (p_kle_id IN NUMBER) IS
1169: SELECT
1170: KIT.OBJECT1_ID1
1171: FROM OKC_K_ITEMS KIT
1172: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1173: KLB.ID = p_kle_id);
1174:
1175: l_tas_id NUMBER;

Line 1309: FROM OKC_K_ITEMS KIT

1305:
1306: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1307: SELECT
1308: KIT.OBJECT1_ID1
1309: FROM OKC_K_ITEMS KIT
1310: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1311: KLB.ID = p_kle_id);
1312:
1313: