APPS.WF_QUEUE dependencies on WF_ACTIVITIES

Line 540: wf_activities a,

536: av.NUMBER_VALUE,
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

Line 840: WF_ACTIVITIES CWA

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
843: and CWPA.ACTIVITY_ITEM_TYPE = CWA.ITEM_TYPE
844: and CWPA.ACTIVITY_NAME = CWA.NAME