APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on FND_LOBS

Line 105: DELETE fnd_lobs fl

101: null;
102: END;
103: /*Delete recodrs for all the initiator thread */
104:
105: DELETE fnd_lobs fl
106: WHERE EXISTS (SELECT 1
107: FROM fnd_attached_documents fad,
108: fnd_documents_vl fdl
109: WHERE fad.pk1_value = l_itemkey(i)

Line 115: DELETE fnd_lobs fl

111: AND fdl.media_id = fl.file_id
112: AND fad.entity_name = 'ERDETAILS');
113:
114: /*Delete recodrs for all the Approver thread */
115: DELETE fnd_lobs fl
116: WHERE EXISTS (SELECT 1
117: FROM fnd_attached_documents fad,
118: fnd_documents_vl fdl
119: WHERE fad.pk1_value = l_itemkey(i)