DBA Data[Home] [Help]

APPS.AMV_WFAPPROVAL_PVT dependencies on WF_ITEMS

Line 800: wf_items wfi

796: select wfl.lookup_code result_code
797: from wf_lookups wfl,
798: wf_activities wfa,
799: wf_process_activities wfpa,
800: wf_items wfi
801: where wfl.lookup_type = wfa.result_type
802: and wfa.name = wfpa.activity_name
803: and wfi.begin_date >= wfa.begin_date
804: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)