APPS.B_RTG_REVS_PKG SQL Statements

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

Line: 10

    SELECT 1
      INTO dummy
      FROM dual
     WHERE X_Effectivity_Date >
                (SELECT nvl(max(effectivity_date), X_Effectivity_Date-1)
                   FROM mtl_rtg_item_revisions
                  WHERE inventory_item_id = X_Inventory_Item_Id
	            AND organization_id   = X_Organization_Id
                    AND process_revision  < X_Process_Revision)
       AND X_Effectivity_Date <
                (SELECT nvl(min(effectivity_date), X_Effectivity_Date+1)
                   FROM mtl_rtg_item_revisions
                  WHERE inventory_item_id = X_Inventory_Item_Id
                    and organization_id   = X_Organization_Id
                    and process_revision  > X_Process_Revision);

Line: 36

    SELECT 1
      INTO dummy
      FROM dual
     WHERE not exists (SELECT 1 from mtl_rtg_item_revisions
                        WHERE organization_id   = X_Organization_Id
                          AND inventory_item_id = X_Inventory_Item_Id
			  AND process_revision  = X_Process_Revision
                       );