APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_POOL_CONTENTS

Line 83: FROM okl_pool_contents opc,

79: IS
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

Line 104: FROM okl_pool_contents opc,

100: CURSOR get_kle_id_csr(p_khr_id NUMBER)
101: IS
102: SELECT opc.kle_id kle_id,
103: MIN(opc.streams_from_date) start_date
104: FROM okl_pool_contents opc,
105: okl_strm_type_b sty
106: WHERE opc.khr_id = p_khr_id
107: AND opc.sty_id = sty.id
108: --AND sty.code = 'RENT'

Line 127: FROM okl_pool_contents opc,

123: IS
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

Line 149: FROM okl_pool_contents opc,

145: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)
146: IS
147: SELECT opc.kle_id kle_id,
148: MIN(opc.streams_from_date) start_date
149: FROM okl_pool_contents opc,
150: okl_strm_type_b sty
151: WHERE opc.khr_id = p_khr_id
152: AND opc.sty_id = sty.id
153: --AND sty.code = 'RENT'

Line 162: FROM okl_pool_contents opc,

158:
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

Line 237: FROM okl_pool_contents opc,

233: -- for a given Lease contract id
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

Line 980: FROM OKL_POOL_CONTENTS opc,

976: IS
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

Line 998: FROM OKL_POOL_CONTENTS opc,

994: CURSOR get_kle_id_csr(p_khr_id NUMBER)
995: IS
996: SELECT opc.kle_id kle_id,
997: MIN(opc.streams_from_date) start_date
998: FROM OKL_POOL_CONTENTS opc,
999: OKL_STRM_TYPE_B sty
1000: WHERE opc.khr_id = p_khr_id
1001: AND opc.sty_id = sty.id
1002: --AND sty.code = 'RENT'

Line 1018: FROM OKL_POOL_CONTENTS opc,

1014: IS
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

Line 1036: FROM OKL_POOL_CONTENTS opc,

1032: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)
1033: IS
1034: SELECT opc.kle_id kle_id,
1035: MIN(opc.streams_from_date) start_date
1036: FROM OKL_POOL_CONTENTS opc,
1037: OKL_STRM_TYPE_B sty
1038: WHERE opc.khr_id = p_khr_id
1039: AND opc.sty_id = sty.id
1040: --AND sty.code = 'RENT'