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 295: From oe_sales_credit_types

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

Line 302: From oe_sales_credit_types

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

Line 322: oe_sales_credit_types sct

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

Line 367: oe_sales_credit_types sct

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