APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_POOLS

Line 84: okl_pools op,

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

Line 128: okl_pools op,

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

Line 163: okl_pools op,

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

Line 238: okl_pools op,

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

Line 981: OKL_POOLS op,

977: SELECT DISTINCT opc.khr_id khr_id,
978: opc.streams_to_date end_date,
979: khr.deal_type deal_type
980: FROM OKL_POOL_CONTENTS opc,
981: OKL_POOLS op,
982: OKL_K_HEADERS khr,
983: OKL_STRM_TYPE_B stytl
984: WHERE op.khr_id = p_inv_id
985: AND op.id = opc.pol_id

Line 1019: OKL_POOLS op,

1015: SELECT DISTINCT opc.khr_id khr_id,
1016: opc.streams_to_date end_date,
1017: khr.deal_type deal_type
1018: FROM OKL_POOL_CONTENTS opc,
1019: OKL_POOLS op,
1020: OKL_K_HEADERS khr,
1021: OKL_STRM_TYPE_B stytl
1022: WHERE op.khr_id = p_inv_id
1023: AND op.id = opc.pol_id