APPS.OKS_OCINT_PUB dependencies on OKS_K_LINES_B

Line 880: ,oks_k_lines_b slines

876: SELECT
877: SUM(NVL(slines.tax_amount,0)) tax_amount
878: FROM
879: okc_k_lines_b clines
880: ,oks_k_lines_b slines
881: WHERE
882: clines.dnz_chr_id = p_chr_id
883: and clines.cle_id = p_line_id
884: and clines.id = slines.cle_id;

Line 893: ,oks_k_lines_b slines

889: SELECT
890: SUM(NVL(slines.tax_amount,0)) tax_amount
891: FROM
892: okc_k_lines_b clines
893: ,oks_k_lines_b slines
894: WHERE
895: clines.dnz_chr_id = p_chr_id
896: AND clines.lse_id IN (1, 19, 46) ---Modified for ER 16039680
897: AND clines.id = slines.cle_id;

Line 2551: UPDATE oks_k_lines_b

2547: CLOSE get_billing_dtls_OM;
2548:
2549: IF l_k_line_rec.coverage_schd_id IS NULL THEN
2550:
2551: UPDATE oks_k_lines_b
2552: SET toplvl_price_qty = (SELECT Sum(quantity)
2553: FROM OKS_SUBSCR_ELEMENTS_V
2554: WHERE DNZ_CLE_ID=l_lineid),
2555: toplvl_uom_code = (SELECT uom_code

Line 2607: UPDATE oks_k_lines_b

2603: FETCH c_extwar_line_amount INTO l_line_tax_amount;
2604: CLOSE c_extwar_line_amount;
2605:
2606: -- Update the topline with the tax amount
2607: UPDATE oks_k_lines_b
2608: SET tax_amount = l_line_tax_amount
2609: WHERE cle_id = l_lineid;
2610:
2611: -- Rollup the topline tax amount to header

Line 2972: -- UPDATE oks_k_lines_b

2968: -- FETCH c_extwar_line_amount INTO l_line_tax_amount;
2969: -- CLOSE c_extwar_line_amount;
2970: --
2971: -- -- Update the topline with the tax amount
2972: -- UPDATE oks_k_lines_b
2973: -- SET tax_amount = l_line_tax_amount
2974: -- WHERE cle_id = l_lineid;
2975: --
2976: -- -- Rollup the topline tax amount to header