DBA Data[Home] [Help]

APPS.WF_QUEUE dependencies on WF_PROCESS_ACTIVITIES

Line 541: wf_process_activities pa

537: av.DATE_VALUE
538: from wf_activity_attr_values av,
539: wf_activity_attributes aa,
540: wf_activities a,
541: wf_process_activities pa
542: where pa.activity_item_type = a.item_type
543: and pa.activity_name = a.name
544: and pa.instance_id=actid
545: and a.begin_date< startdate and nvl(a.end_date,startdate) >= startdate

Line 838: WF_PROCESS_ACTIVITIES CWPA,

834: -- move the BEGIN_DATE, SYSDATE comparion to a separate clause
835: SELECT CWA.COST, CWIAS.BEGIN_DATE
836: into cost, l_begdate
837: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
838: WF_PROCESS_ACTIVITIES CWPA,
839: WF_ITEMS WI,
840: WF_ACTIVITIES CWA
841: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'
842: and CWIAS.PROCESS_ACTIVITY = CWPA.INSTANCE_ID