APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on WF_ITEMS_V

Line 22: select nvl(PARENT_ITEM_KEY,ITEM_KEY), ITEM_KEY from wf_items_v

18: WHERE request_id = p_request_id
19: AND nvl(p_person_id, person_id) = person_id ;
20:
21: CURSOR c_get_item_key (p_request_id NUMBER) is
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,