APPS.OKL_SUB_PVT dependencies on OKL_STRM_TYPE_B

Line 1369: FROM OKL_STRM_TYPE_B styb,

1365: -- sjalasut, changed the cursor to exclude stream type class
1366: -- and included stream type purpose as part of bug 3985580.
1367: CURSOR styb_csr (p_stream_type_id IN number) IS
1368: SELECT 'Y'
1369: FROM OKL_STRM_TYPE_B styb,
1370: FND_LOOKUPS lkup
1371: WHERE styb.id = p_stream_type_id
1372: AND sysdate between nvl(styb.start_date,sysdate) and nvl(styb.end_date,sysdate)
1373: AND lkup.lookup_code = styb.STREAM_TYPE_PURPOSE

Line 2391: FROM Okl_Strm_Type_B

2387: l_okl_subsidies_v_fk2 okl_subsidies_v_fk2_csr%ROWTYPE;
2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'
2391: FROM Okl_Strm_Type_B
2392: WHERE okl_strm_type_b.id = p_id;
2393: l_okl_subsidies_v_fk6 okl_subsidies_v_fk6_csr%ROWTYPE;
2394:
2395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2392: WHERE okl_strm_type_b.id = p_id;

2388:
2389: CURSOR okl_subsidies_v_fk6_csr (p_id IN NUMBER) IS
2390: SELECT 'x'
2391: FROM Okl_Strm_Type_B
2392: WHERE okl_strm_type_b.id = p_id;
2393: l_okl_subsidies_v_fk6 okl_subsidies_v_fk6_csr%ROWTYPE;
2394:
2395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2396: l_row_notfound BOOLEAN := TRUE;