1820: Cursor Sales_credit_cur IS
1821: Select Ctc_id
1822: ,sales_credit_type_id1
1823: ,percent, sales_group_id
1824: From OKS_K_SALES_CREDITS
1825: Where cle_id = p_id;
1826:
1827: --added by mchoudha for bug#4174921
1828: --If line level salescredits are not present then
1834: Select Ctc_id
1835: ,sales_credit_type_id1
1836: ,percent
1837: ,sales_group_id
1838: From OKS_K_SALES_CREDITS
1839: Where chr_id = p_hdr_id
1840: And cle_id IS NULL;
1841:
1842:
2595: Cursor Sales_credit_cur(p_id NUMBER) IS
2596: Select Ctc_id
2597: ,sales_credit_type_id1
2598: ,percent
2599: From OKS_K_SALES_CREDITS
2600: Where cle_id = p_id;
2601:
2602:
2603: Cursor chk_price_break_cur(p_id IN NUMBER) IS