776: FROM wf_item_activity_statuses ias,
777: wf_process_activities pa,
778: wf_activities_vl ac,
779: wf_activities_vl ap,
780: wf_items i
781: WHERE ias.item_type = 'ARCMREQ'
782: AND ias.item_key = p_request_id
783: AND ias.process_activity = pa.instance_id
784: AND pa.activity_name = ac.name
967: FROM wf_item_activity_statuses ias,
968: wf_process_activities pa,
969: wf_activities_vl ac,
970: wf_activities_vl ap,
971: wf_items i
972: WHERE ias.item_type = 'ARCMREQ'
973: AND ias.item_key = p_request_id
974: AND ias.process_activity = pa.instance_id
975: AND pa.activity_name = ac.name