APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_SALES_CREDITS

Line 3958: FROM oe_sales_credits

3954: IS
3955: CURSOR l_scredit_csr
3956: IS
3957: SELECT salesrep_id, sales_credit_type_id, PERCENT, sales_group_id
3958: FROM oe_sales_credits
3959: WHERE line_id = p_order_line_id;
3960:
3961: /* Cursor l_salesgroup_csr(p_salesrep_id Number) Is
3962: SELECT DISTINCT grp.group_name, grp.group_id

Line 4041: FROM oe_sales_credits

4037: IS
4038: CURSOR l_scredit_csr
4039: IS
4040: SELECT salesrep_id, sales_credit_type_id, PERCENT, sales_group_id
4041: FROM oe_sales_credits
4042: WHERE header_id = p_order_hdr_id AND line_id IS NULL;
4043:
4044: i INTEGER := 0;
4045: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;