APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 1115: FROM okc_subclass_top_line stl,

1111: -- Cursor to sum up oec for given model line
1112: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1113: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1114: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,
1117: okc_line_styles_b lse1,
1118: okc_k_items_v cim,
1119: okc_k_lines_v cle

Line 1134: FROM okc_subclass_top_line stl,

1130: -- Cursor to sum up oec of addon line for a given top line
1131: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1132: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1133: SELECT SUM(cle.price_unit* cim.number_of_items) oec
1134: FROM okc_subclass_top_line stl,
1135: okc_line_styles_b lse3,
1136: okc_line_styles_b lse2,
1137: okc_line_styles_b lse1,
1138: okc_k_items_v cim,

Line 1153: FROM okc_subclass_top_line stlx,

1149: AND lse3.id = stl.lse_id
1150: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
1151: --AND cle.cle_id IN (SELECT cle.id
1152: AND exists (SELECT 1 --cle.id
1153: FROM okc_subclass_top_line stlx,
1154: okc_line_styles_b lse2x,
1155: okc_line_styles_b lse1x,
1156: okc_k_lines_b clex
1157: WHERE clex.cle_id = p_top_cle_id

Line 1235: FROM okc_subclass_top_line stl,

1231: CURSOR c_nr_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1232: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1233: p_line_type VARCHAR2) IS
1234: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1235: FROM okc_subclass_top_line stl,
1236: okc_line_styles_b lse2,
1237: okc_line_styles_b lse1,
1238: okc_k_items_v cim,
1239: okc_k_lines_v cle

Line 15620: FROM okc_subclass_top_line stl,

15616: -- Cursor to sum up asset cost for given Asset line
15617: CURSOR c_asset_cost(p_line_id NUMBER,
15618: p_dnz_chr_id NUMBER) IS
15619: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
15620: FROM okc_subclass_top_line stl,
15621: okc_line_styles_b lse2,
15622: okc_line_styles_b lse1,
15623: okc_k_items_v cim,
15624: okc_k_lines_v cle

Line 15640: FROM okc_subclass_top_line stl,

15636: -- Cursor to sum up addon amount for a given line
15637: CURSOR c_addon(p_line_id NUMBER,
15638: p_dnz_chr_id NUMBER) IS
15639: SELECT SUM(cle.price_unit* cim.number_of_items) add_on
15640: FROM okc_subclass_top_line stl,
15641: okc_line_styles_b lse3,
15642: okc_line_styles_b lse2,
15643: okc_line_styles_b lse1,
15644: okc_k_items_v cim,

Line 15658: FROM okc_subclass_top_line stlx,

15654: AND lse3.lty_code = 'FREE_FORM1'
15655: AND lse3.id = stl.lse_id
15656: AND stl.scs_code IN ('LEASE','LOAN')
15657: AND exists (SELECT 1
15658: FROM okc_subclass_top_line stlx,
15659: okc_line_styles_b lse2x,
15660: okc_line_styles_b lse1x,
15661: okc_k_lines_b clex
15662: WHERE clex.cle_id = p_line_id

Line 15925: FROM okc_subclass_top_line stl,

15921:
15922: CURSOR c_addon_cost_csr (p_contract_id IN NUMBER,
15923: p_contract_line_id IN NUMBER) IS
15924: SELECT SUM(cle.price_unit* cim.number_of_items) add_on_cost
15925: FROM okc_subclass_top_line stl,
15926: okc_line_styles_b lse3,
15927: okc_line_styles_b lse2,
15928: okc_line_styles_b lse1,
15929: okc_k_items_v cim,

Line 15943: FROM okc_subclass_top_line stlx,

15939: AND lse3.lty_code = 'FREE_FORM1' -- G_FIN_LINE_LTY_CODE
15940: AND lse3.id = stl.lse_id
15941: AND stl.scs_code IN ('LEASE','LOAN')
15942: AND exists (SELECT 1
15943: FROM okc_subclass_top_line stlx,
15944: okc_line_styles_b lse2x,
15945: okc_line_styles_b lse1x,
15946: okc_k_lines_b clex
15947: WHERE clex.cle_id = p_contract_line_id -- lse_id = 33>