2938: -- added cursor for sales_credit -govind
2939: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
2940: IS
2941: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2942: FROM oks_k_sales_credits_v
2943: WHERE cle_id = p_cle_id;
2944:
2945: CURSOR l_rel_csr (
2946: p_line_id NUMBER,
2963: --mmadhavi bug 4174921
2964: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
2965: IS
2966: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
2967: FROM oks_k_sales_credits_v
2968: WHERE chr_id = p_chr_id AND cle_id IS NULL;
2969:
2970: --mmadhavi bug 4174921
2971: p_line_id NUMBER;
4630: CURSOR scredit_csr
4631: IS
4632: SELECT PERCENT, ctc_id, sales_credit_type_id1,
4633: sales_credit_type_id2, sales_group_id
4634: FROM oks_k_sales_credits_v
4635: WHERE chr_id = p_header_id AND cle_id IS NULL;
4636:
4637: l_scr_rec scredit_csr%ROWTYPE;
4638: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;