APPS.PO_ASL_UPGRADE_SV3 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

    SELECT  nvl(sum(split), 0)
    INTO    x_total_allocation
    FROM    PO_AUTOSOURCE_VENDORS
    WHERE   autosource_rule_id = x_autosource_rule_id;

Line: 44

	SELECT  sum(round(split*(100/x_total_allocation)))
	INTO	x_total_allocation
	FROM	po_autosource_vendors
	WHERE   autosource_rule_id = x_autosource_rule_id;