774: ias.activity_result_code result_code,
775: ias.assigned_user -- user
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
775: ias.assigned_user -- user
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
965: SELECT count(*)
966: INTO l_count_activities
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
966: INTO l_count_activities
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