DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on WF_ACTIVITIES

Line 944: from WF_ITEMS wfi, WF_ACTIVITIES wfa

940:
941: BEGIN
942:
943: select ceil(wfi.BEGIN_DATE - wfa.begin_Date) into l_SkipFlag
944: from WF_ITEMS wfi, WF_ACTIVITIES wfa
945: WHERE wfi.ITEM_TYPE = 'IEXSTRY'
946: and wfa.version = (select min(wa.version) from wf_activities wa
947: where wa.item_type=wfa.item_type
948: and wa.name=wfa.name)

Line 946: and wfa.version = (select min(wa.version) from wf_activities wa

942:
943: select ceil(wfi.BEGIN_DATE - wfa.begin_Date) into l_SkipFlag
944: from WF_ITEMS wfi, WF_ACTIVITIES wfa
945: WHERE wfi.ITEM_TYPE = 'IEXSTRY'
946: and wfa.version = (select min(wa.version) from wf_activities wa
947: where wa.item_type=wfa.item_type
948: and wa.name=wfa.name)
949: and wfi.item_key = l_Strategy_id
950: and wfa.item_type = wfi.item_type AND