APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_POOLS

Line 86: okl_pools op,

82: SELECT DISTINCT opc.khr_id khr_id,
83: opc.streams_to_date end_date,
84: khr.deal_type deal_type
85: FROM okl_pool_contents opc,
86: okl_pools op,
87: okl_k_headers khr,
88: -- Changed for User Defined Streams
89: --okl_strm_type_tl stytl
90: okl_strm_type_b stytl

Line 130: okl_pools op,

126: SELECT DISTINCT opc.khr_id khr_id,
127: opc.streams_to_date end_date,
128: khr.deal_type deal_type
129: FROM okl_pool_contents opc,
130: okl_pools op,
131: okl_k_headers khr,
132: -- Changed for User Defined Streams
133: --okl_strm_type_tl stytl
134: okl_strm_type_b stytl

Line 165: okl_pools op,

161: CURSOR get_inv_pend_csr (p_khr_id NUMBER)
162: IS
163: SELECT DISTINCT op.khr_id
164: FROM okl_pool_contents opc,
165: okl_pools op,
166: okl_strm_type_b sty
167: WHERE op.id = opc.pol_id
168: AND opc.khr_id = p_khr_id
169: AND opc.sty_id = sty.id

Line 240: okl_pools op,

236: CURSOR get_inv_csr (p_khr_id NUMBER)
237: IS
238: SELECT DISTINCT op.khr_id
239: FROM okl_pool_contents opc,
240: okl_pools op,
241: okl_strm_type_b sty
242: WHERE op.id = opc.pol_id
243: AND opc.khr_id = p_khr_id
244: AND opc.sty_id = sty.id

Line 1446: OKL_POOLS op,

1442: SELECT DISTINCT opc.khr_id khr_id,
1443: opc.streams_to_date end_date,
1444: khr.deal_type deal_type
1445: FROM OKL_POOL_CONTENTS opc,
1446: OKL_POOLS op,
1447: OKL_K_HEADERS khr,
1448: OKL_STRM_TYPE_B stytl
1449: WHERE op.khr_id = p_inv_id
1450: AND op.id = opc.pol_id

Line 1484: OKL_POOLS op,

1480: SELECT DISTINCT opc.khr_id khr_id,
1481: opc.streams_to_date end_date,
1482: khr.deal_type deal_type
1483: FROM OKL_POOL_CONTENTS opc,
1484: OKL_POOLS op,
1485: OKL_K_HEADERS khr,
1486: OKL_STRM_TYPE_B stytl
1487: WHERE op.khr_id = p_inv_id
1488: AND op.id = opc.pol_id