DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 23451: okc_subclass_top_line ostl

23447:
23448: CURSOR top_lse_csr (p_lty_code VARCHAR2) IS
23449: SELECT id
23450: FROM OKC_LINE_STYLES_B ols,
23451: okc_subclass_top_line ostl
23452: WHERE LTY_CODE = p_lty_code
23453: AND ostl.scs_code = 'LEASE'
23454: AND ols.id = ostl.lse_id;
23455:

Line 23461: okc_subclass_top_line ostl

23457: p_top_line_lty_code VARCHAR2) IS
23458: SELECT ols2.id
23459: FROM okc_line_styles_v ols1,
23460: okc_line_styles_v ols2,
23461: okc_subclass_top_line ostl
23462: WHERE ostl.scs_code = 'LEASE'
23463: AND ostl.lse_id = ols1.id
23464: AND ols1.lty_code = p_top_line_lty_code
23465: AND ols2.lty_code = p_lty_code