APPS.OKL_QA_SECURITIZATION dependencies on OKC_LINE_STYLES_B

Line 50: FROM okc_line_styles_b rev_style,

46: WHERE pool.id = pcon.pol_id
47: AND pool.khr_id = p_chr_id
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'

Line 62: FROM okc_line_styles_b rev_style,

58:
59: CURSOR l_rev_strm_comp_csr(p_cle_id IN NUMBER) IS
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

Line 92: FROM okc_line_styles_b rev_style,

88: FROM okl_strm_type_v strm
89: WHERE stream_type_subclass = 'INVESTOR_DISBURSEMENT'
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'

Line 112: okc_line_styles_b lseb

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
116: AND lseb.lty_code = 'REVENUE_SHARE'

Line 135: okc_line_styles_b lseb

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
139: AND lseb.lty_code = 'REVENUE_SHARE'

Line 148: , okc_line_styles_b lse

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
152: , okc_k_items cit

Line 183: okc_line_styles_b lseb

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
187: AND lseb.lty_code = 'REVENUE_SHARE';