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 840: WF_PROCESS_ACTIVITIES CWPA,

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