APPS.B_RTG_REVS_PKG dependencies on DUAL

Line 12: FROM dual

8: dummy NUMBER;
9: BEGIN
10: SELECT 1
11: INTO dummy
12: FROM dual
13: WHERE X_Effectivity_Date >
14: (SELECT nvl(max(effectivity_date), X_Effectivity_Date-1)
15: FROM mtl_rtg_item_revisions
16: WHERE inventory_item_id = X_Inventory_Item_Id

Line 38: FROM dual

34: dummy NUMBER;
35: BEGIN
36: SELECT 1
37: INTO dummy
38: FROM dual
39: WHERE not exists (SELECT 1 from mtl_rtg_item_revisions
40: WHERE organization_id = X_Organization_Id
41: AND inventory_item_id = X_Inventory_Item_Id
42: AND process_revision = X_Process_Revision