APPS.PO_ASL_UPGRADE_SV3 dependencies on PO_AUTOSOURCE_VENDORS

Line 28: FROM PO_AUTOSOURCE_VENDORS

24:
25: x_progress := '010';
26: SELECT nvl(sum(split), 0)
27: INTO x_total_allocation
28: FROM PO_AUTOSOURCE_VENDORS
29: WHERE autosource_rule_id = x_autosource_rule_id;
30:
31: EXCEPTION
32: WHEN NO_DATA_FOUND THEN

Line 46: FROM po_autosource_vendors

42:
43: x_progress := '020';
44: SELECT sum(round(split*(100/x_total_allocation)))
45: INTO x_total_allocation
46: FROM po_autosource_vendors
47: WHERE autosource_rule_id = x_autosource_rule_id;
48:
49: IF x_total_allocation < 100 THEN
50: x_add_percent := 'Y';