APPS.OKL_QA_SECURITIZATION dependencies on OKC_K_LINES_B

Line 52: okc_k_lines_b rev

48: AND not exists (
49: SELECT 'Y'
50: FROM okc_line_styles_b rev_style,
51: okl_k_lines revl,
52: okc_k_lines_b rev
53: WHERE rev.lse_id = rev_style.id
54: AND rev_style.lty_code = 'REVENUE_SHARE'
55: AND revl.id = rev.id
56: AND revl.sty_id = pcon.sty_id

Line 64: okc_k_lines_b rev,

60: SELECT rev.id, rev.cle_id, revl.sty_id,revl.percent_stake,
61: strm.stream_type_subclass
62: FROM okc_line_styles_b rev_style,
63: okl_k_lines revl,
64: okc_k_lines_b rev,
65: okl_strm_type_v strm
66: WHERE rev.lse_id = rev_style.id
67: AND rev_style.lty_code = 'REVENUE_SHARE'
68: AND revl.id = rev.id

Line 94: okc_k_lines_b rev

90: AND not exists (
91: SELECT 'Y'
92: FROM okc_line_styles_b rev_style,
93: okl_k_lines revl,
94: okc_k_lines_b rev
95: WHERE rev.lse_id = rev_style.id
96: AND rev_style.lty_code = 'REVENUE_SHARE'
97: AND revl.id = rev.id
98: AND revl.sty_id = strm.id

Line 111: okc_k_lines_b cles,

107: -- To check if revenue shares exist for each investor.
108: CURSOR l_okl_inv_sty_subclass_csr(p_investor_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
109: SELECT 1
110: FROM okl_k_lines kleb,
111: okc_k_lines_b cles,
112: okc_line_styles_b lseb
113: WHERE kleb.id = cles.id
114: AND cles.lse_id = lseb.id
115: AND cles.cle_id = p_investor_id

Line 134: okc_k_lines_b cles,

130: --Bug# 5032252 --start
131: CURSOR l_rev_share_per_csr(p_investor_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
132: SELECT kleb.percent_stake
133: FROM okl_k_lines kleb,
134: okc_k_lines_b cles,
135: okc_line_styles_b lseb
136: WHERE kleb.id = cles.id
137: AND cles.lse_id = lseb.id
138: AND cles.cle_id = p_investor_id

Line 147: FROM okc_k_lines_b cle

143: --CURSOR for selecting wheteher payment line exist for INCOME fee or not
144: CURSOR payment_csr (p_agreement_id IN NUMBER )is
145: select hzp.party_name partyname
146: , okl_strmtyp.name streamtypename
147: FROM okc_k_lines_b cle
148: , okc_line_styles_b lse
149: , okl_k_lines kle
150: , okc_k_party_roles_b parb
151: , hz_parties hzp

Line 182: okc_k_lines_b cles,

178: CURSOR l_rev_share_dtls_csr(p_investor_id IN NUMBER) IS
179: SELECT kleb.stream_type_subclass,
180: kleb.percent_stake
181: FROM okl_k_lines kleb,
182: okc_k_lines_b cles,
183: okc_line_styles_b lseb
184: WHERE kleb.id = cles.id
185: AND cles.lse_id = lseb.id
186: AND cles.cle_id = p_investor_id