9852:
9853: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
9854: IS
9855: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
9856: FROM oks_k_sales_credits_v
9857: WHERE chr_id = p_chr_id AND cle_id IS NULL;
9858: BEGIN
9859: x_return_status := okc_api.g_ret_sts_success;
9860:
10325:
10326: CURSOR l_sales_credit_csr (p_cle_id NUMBER)
10327: IS
10328: SELECT ctc_id, sales_credit_type_id1, PERCENT, sales_group_id
10329: FROM oks_k_sales_credits_v
10330: WHERE cle_id = p_cle_id;
10331:
10332: l_sc_ctr NUMBER;
10333: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;