APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on PSP_EFF_REPORT_APPROVALS

Line 26: from psp_eff_Report_approvals pera,

22: select nvl(PARENT_ITEM_KEY,ITEM_KEY), ITEM_KEY from wf_items_v
23: where ITEM_TYPE = 'PSPERAVL'
24: and ITEM_KEY in (
25: select pera.WF_ITEM_KEY --into l_itemkey
26: from psp_eff_Report_approvals pera,
27: psp_eff_report_details perd,
28: psp_eff_reports per
29: where pera.EFFORT_REPORT_DETAIL_ID = perd.EFFORT_REPORT_DETAIL_ID
30: and perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID

Line 145: delete from psp_eff_report_approvals where effort_report_detail_id in (

141: */
142:
143:
144: FORALL i in 1.. eff_report_master_rec.effort_report_id.count
145: delete from psp_eff_report_approvals where effort_report_detail_id in (
146: select effort_report_detail_id from psp_eff_report_details where effort_report_id
147: = eff_report_master_rec.effort_report_id(i));
148:
149: FORALL i in 1.. eff_report_master_rec.effort_report_id.count