APPS.OE_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);

Line 60: FROM oe_sales_credits sc,

56: -- FP bug 3872166
57: l_line_no varchar2(30);
58: Cursor C_LSC_Quota_Total(p_line_id number) IS
59: SELECT sum(Percent) Per_total
60: FROM oe_sales_credits sc,
61: oe_sales_credit_types sct
62: WHERE line_id = p_line_id
63: AND sc.sales_credit_type_id = sct.sales_credit_type_id
64: AND sct.quota_flag = 'Y';