APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 970: FROM okc_subclass_top_line stl,

966: -- Cursor to sum up oec for given model line
967: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
968: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
969: SELECT SUM(cle.price_unit * cim.number_of_items) oec
970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,
972: okc_line_styles_b lse1,
973: okc_k_items_v cim,
974: okc_k_lines_v cle

Line 989: FROM okc_subclass_top_line stl,

985: -- Cursor to sum up oec of addon line for a given top line
986: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
987: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
988: SELECT SUM(cle.price_unit* cim.number_of_items) oec
989: FROM okc_subclass_top_line stl,
990: okc_line_styles_b lse3,
991: okc_line_styles_b lse2,
992: okc_line_styles_b lse1,
993: okc_k_items_v cim,

Line 1008: FROM okc_subclass_top_line stlx,

1004: AND lse3.id = stl.lse_id
1005: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
1006: --AND cle.cle_id IN (SELECT cle.id
1007: AND exists (SELECT 1 --cle.id
1008: FROM okc_subclass_top_line stlx,
1009: okc_line_styles_b lse2x,
1010: okc_line_styles_b lse1x,
1011: okc_k_lines_b clex
1012: WHERE clex.cle_id = p_top_cle_id

Line 14388: FROM okc_subclass_top_line stl,

14384: -- Cursor to sum up asset cost for given Asset line
14385: CURSOR c_asset_cost(p_line_id NUMBER,
14386: p_dnz_chr_id NUMBER) IS
14387: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
14388: FROM okc_subclass_top_line stl,
14389: okc_line_styles_b lse2,
14390: okc_line_styles_b lse1,
14391: okc_k_items_v cim,
14392: okc_k_lines_v cle

Line 14408: FROM okc_subclass_top_line stl,

14404: -- Cursor to sum up addon amount for a given line
14405: CURSOR c_addon(p_line_id NUMBER,
14406: p_dnz_chr_id NUMBER) IS
14407: SELECT SUM(cle.price_unit* cim.number_of_items) add_on
14408: FROM okc_subclass_top_line stl,
14409: okc_line_styles_b lse3,
14410: okc_line_styles_b lse2,
14411: okc_line_styles_b lse1,
14412: okc_k_items_v cim,

Line 14426: FROM okc_subclass_top_line stlx,

14422: AND lse3.lty_code = 'FREE_FORM1'
14423: AND lse3.id = stl.lse_id
14424: AND stl.scs_code IN ('LEASE','LOAN')
14425: AND exists (SELECT 1
14426: FROM okc_subclass_top_line stlx,
14427: okc_line_styles_b lse2x,
14428: okc_line_styles_b lse1x,
14429: okc_k_lines_b clex
14430: WHERE clex.cle_id = p_line_id

Line 14693: FROM okc_subclass_top_line stl,

14689:
14690: CURSOR c_addon_cost_csr (p_contract_id IN NUMBER,
14691: p_contract_line_id IN NUMBER) IS
14692: SELECT SUM(cle.price_unit* cim.number_of_items) add_on_cost
14693: FROM okc_subclass_top_line stl,
14694: okc_line_styles_b lse3,
14695: okc_line_styles_b lse2,
14696: okc_line_styles_b lse1,
14697: okc_k_items_v cim,

Line 14711: FROM okc_subclass_top_line stlx,

14707: AND lse3.lty_code = 'FREE_FORM1' -- G_FIN_LINE_LTY_CODE
14708: AND lse3.id = stl.lse_id
14709: AND stl.scs_code IN ('LEASE','LOAN')
14710: AND exists (SELECT 1
14711: FROM okc_subclass_top_line stlx,
14712: okc_line_styles_b lse2x,
14713: okc_line_styles_b lse1x,
14714: okc_k_lines_b clex
14715: WHERE clex.cle_id = p_contract_line_id -- lse_id = 33>