APPS.OE_VALIDATE_HEADER_SCREDIT dependencies on OE_SALES_CREDITS

Line 18: From oe_sales_credits

14: ,p_sales_credit_type_id NUMBER
15: ,p_header_id NUMBER
16: ,p_sales_credit_id NUMBER) IS
17: Select 'DUPLICATE'
18: From oe_sales_credits
19: Where header_id = p_header_id
20: And line_id is null
21: And salesrep_id = p_salesrep_id
22: And sales_credit_type_id = p_sales_credit_type_id

Line 59: FROM oe_sales_credits sc,

55:
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

Line 728: From oe_sales_credits sc,

724: ) IS
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