APPS.PRODUCT_FAMILY_PKG dependencies on DUAL

Line 64: SELECT 'X' date_available FROM sys.dual

60: X_Bill_Sequence_Id NUMBER,
61: X_Rowid VARCHAR2) RETURN BOOLEAN IS
62: X_Count NUMBER := 0;
63: CURSOR X_All_Dates IS
64: SELECT 'X' date_available FROM sys.dual
65: WHERE EXISTS (
66: SELECT 1 from BOM_Inventory_Components
67: WHERE Component_Item_Id = X_Member_Item_Id
68: AND Bill_Sequence_Id = X_Bill_Sequence_Id

Line 183: SELECT 1 INTO dummy FROM dual

179: X_Organization_Id NUMBER) RETURN BOOLEAN
180: IS
181: dummy NUMBER;
182: BEGIN
183: SELECT 1 INTO dummy FROM dual
184: WHERE not exists
185: (SELECT 1 FROM bom_bill_of_materials
186: WHERE assembly_item_id = X_Assembly_item_id
187: AND organization_id = X_organization_id