APPS.OKL_SSC_WF dependencies on OKC_K_LINES_B

Line 935: CURSOR c_get_org_id (p_kle_id IN OKC_K_LINES_B.CLE_ID%TYPE)

931:
932: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - End
933:
934: --For bug 8933908 by NIKSHAH : START
935: CURSOR c_get_org_id (p_kle_id IN OKC_K_LINES_B.CLE_ID%TYPE)
936: IS
937: select chr.org_id
938: from okc_k_headers_all_b chr,
939: okc_k_lines_b cle

Line 939: okc_k_lines_b cle

935: CURSOR c_get_org_id (p_kle_id IN OKC_K_LINES_B.CLE_ID%TYPE)
936: IS
937: select chr.org_id
938: from okc_k_headers_all_b chr,
939: okc_k_lines_b cle
940: where chr.id = cle.dnz_chr_id
941: and cle.cle_id = p_kle_id
942: and rownum = 1;
943:

Line 1172: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE

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;
1176: l_kle_id NUMBER;

Line 1310: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE

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:
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;