APPS.OE_VALIDATE_HEADER_SCREDIT dependencies on OE_SALES_CREDIT_TYPES

Line 60: oe_sales_credit_types sct

56: l_percent_total NUMBER;
57: CURSOR C_HSC_Quota_Total(p_header_id number) IS
58: SELECT sum(Percent) Per_total
59: FROM oe_sales_credits sc,
60: oe_sales_credit_types sct
61: WHERE header_id = p_header_id
62: AND sct.sales_credit_type_id = sc.sales_credit_type_id
63: AND line_id is null
64: AND sct.quota_flag = 'Y';

Line 729: oe_sales_credit_types sct

725: l_percent_total Number;
726: Cursor C_HSC_Quota_Total(p_header_id number) IS
727: Select sum(Percent) Per_total
728: From oe_sales_credits sc,
729: oe_sales_credit_types sct
730: Where header_id = p_header_id
731: And sct.sales_credit_type_id = sc.sales_credit_type_id
732: And line_id is null
733: And sct.quota_flag = 'Y';