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 263: from oe_sales_credits

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

Line 321: From oe_sales_credits sc,

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

Line 366: From oe_sales_credits sc,

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