APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_SALES_CREDITS

Line 19: From oe_sales_credits sc,

15: l_percent_total Number;
16:
17: Cursor C_LSC_Quota_Total(p_line_id number) IS
18: Select sum(Percent) Per_total
19: From oe_sales_credits sc,
20: oe_sales_credit_types sct
21: Where line_id = p_line_id
22: And sct.sales_credit_type_id = sc.sales_credit_type_id
23: And sct.quota_flag = 'Y';

Line 264: from oe_sales_credits

260: END IF;
261: BEGIN
262: Select '1', sales_credit_id, nvl(percent,0)
263: INTO l_temp, l_sales_credit_id, l_q_percent
264: from oe_sales_credits
265: Where header_id = i.header_id
266: AND line_id = i.line_id
267: And sales_credit_type_id = l_sales_credit_type_id
268: AND salesrep_id = l_salesrep_id;

Line 322: From oe_sales_credits sc,

318:
319: oe_debug_pub.Add(' In create and quota');
320: Select nvl(sum(Percent),0) Per_total
321: Into l_per_total
322: From oe_sales_credits sc,
323: oe_sales_credit_types sct
324: Where header_id = i.header_id
325: AND line_id = i.line_id
326: And sct.sales_credit_type_id = sc.sales_credit_type_id

Line 367: From oe_sales_credits sc,

363: IF l_new_quota_flag = 'Y' THEN
364:
365: Select nvl(sum(Percent),0) Per_total
366: Into l_per_total
367: From oe_sales_credits sc,
368: oe_sales_credit_types sct
369: Where header_id = i.header_id
370: AND line_id = i.line_id
371: And sct.sales_credit_type_id = sc.sales_credit_type_id