DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_SALES_CREDITS

Line 4004: FROM oe_sales_credits

4000: IS
4001: CURSOR l_scredit_csr
4002: IS
4003: SELECT salesrep_id, sales_credit_type_id, PERCENT, sales_group_id
4004: FROM oe_sales_credits
4005: WHERE line_id = p_order_line_id;
4006:
4007: /* Cursor l_salesgroup_csr(p_salesrep_id Number) Is
4008: SELECT DISTINCT grp.group_name, grp.group_id

Line 4087: FROM oe_sales_credits

4083: IS
4084: CURSOR l_scredit_csr
4085: IS
4086: SELECT salesrep_id, sales_credit_type_id, PERCENT, sales_group_id
4087: FROM oe_sales_credits
4088: WHERE header_id = p_order_hdr_id AND line_id IS NULL;
4089:
4090: i INTEGER := 0;
4091: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;