DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE_SCREDIT dependencies on OE_SALES_CREDIT_TYPES

Line 61: oe_sales_credit_types sct

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';
65: