DBA Data[Home] [Help]

APPS.QPR_WKFL_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 737: from WF_ITEM_ACTIVITY_STATUSES act, wf_process_activities pa

733: return;
734: end;
735:
736: select pa.activity_name into l_activity_name
737: from WF_ITEM_ACTIVITY_STATUSES act, wf_process_activities pa
738: where act.item_type = QPR_NTFN_ITM_TYPE
739: and act.item_key = l_item_key
740: and act.activity_status = 'NOTIFIED'
741: and act.process_activity = pa.instance_id