DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 23262: okc_subclass_top_line ostl

23258:
23259: CURSOR top_lse_csr (p_lty_code VARCHAR2) IS
23260: SELECT id
23261: FROM OKC_LINE_STYLES_B ols,
23262: okc_subclass_top_line ostl
23263: WHERE LTY_CODE = p_lty_code
23264: AND ostl.scs_code = 'LEASE'
23265: AND ols.id = ostl.lse_id;
23266:

Line 23272: okc_subclass_top_line ostl

23268: p_top_line_lty_code VARCHAR2) IS
23269: SELECT ols2.id
23270: FROM okc_line_styles_v ols1,
23271: okc_line_styles_v ols2,
23272: okc_subclass_top_line ostl
23273: WHERE ostl.scs_code = 'LEASE'
23274: AND ostl.lse_id = ols1.id
23275: AND ols1.lty_code = p_top_line_lty_code
23276: AND ols2.lty_code = p_lty_code