1350: cursor getactname(req_header_id varchar2) is
1351: select pa.instance_label
1352: from wf_item_activity_statuses ias,
1353: wf_process_activities pa,
1354: wf_activities_vl ac,
1355: wf_activities_vl ap,
1356: wf_items i
1357: where ias.item_type = 'POREQ'
1358: and ias.item_key = req_header_id
1351: select pa.instance_label
1352: from wf_item_activity_statuses ias,
1353: wf_process_activities pa,
1354: wf_activities_vl ac,
1355: wf_activities_vl ap,
1356: wf_items i
1357: where ias.item_type = 'POREQ'
1358: and ias.item_key = req_header_id
1359: and ias.process_activity = pa.instance_id