APPS.OE_CNCL_VALIDATE_LINE_SCREDIT dependencies on OE_SALES_CREDITS
Line 19: FROM oe_sales_credits
15: ,p_sales_credit_type_id NUMBER
16: ,p_line_id NUMBER
17: ,p_sales_credit_id NUMBER) IS
18: SELECT 'DUPLICATE' 19: FROM oe_sales_credits 20: WHERE line_id = p_line_id
21: AND salesrep_id = p_salesrep_id
22: AND sales_credit_type_id = p_sales_credit_type_id
23: AND sales_credit_id <> nvl(p_sales_credit_id,-5);