APPS.QPR_WKFL_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 716: l_activity_name wf_process_activities.activity_name%type;

712: p_status in varchar2,
713: retcode out nocopy number,
714: errbuf out nocopy varchar2) is
715: l_item_key varchar2(240);
716: l_activity_name wf_process_activities.activity_name%type;
717: l_status varchar2(240);
718: l_init_key varchar2(240);
719: begin
720: l_init_key := 'TOAPP_' || p_response_id || p_current_user;

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