APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_SALES_CREDIT_TYPES

Line 20: oe_sales_credit_types sct

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

Line 296: From oe_sales_credit_types

292: BEGIN
293:
294: Select quota_flag
295: Into l_new_quota_flag
296: From oe_sales_credit_types
297: Where sales_credit_type_id = l_new_sales_credit_type_id;
298:
299: IF l_new_sales_credit_type_id <> l_old_sales_credit_type_id THEN
300:

Line 303: From oe_sales_credit_types

299: IF l_new_sales_credit_type_id <> l_old_sales_credit_type_id THEN
300:
301: Select quota_flag
302: Into l_old_quota_flag
303: From oe_sales_credit_types
304: Where sales_credit_type_id = l_old_sales_credit_type_id;
305:
306: ELSE
307:

Line 323: oe_sales_credit_types sct

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
327: And sct.quota_flag = 'Y';

Line 368: oe_sales_credit_types sct

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
372: And sct.quota_flag = 'Y';