APPS.ZPB_WF_NTF dependencies on ZPB_ANALYSIS_CYCLE_INSTANCES

Line 361: from ZPB_ANALYSIS_CYCLE_INSTANCES

357: from zpb_analysis_cycle_tasks where task_id = TaskId) ;
358:
359: select INSTANCE_DESCRIPTION
360: into InstDesc
361: from ZPB_ANALYSIS_CYCLE_INSTANCES
362: where INSTANCE_AC_ID = InstanceID;
363:
364: -- set descripton
365: wf_engine.SetItemAttrText(Itemtype => ItemType,

Line 1585: ZPB_BUSINESS_AREAS_VL v, zpb_analysis_cycle_instances i

1581:
1582: select t.task_name, ac.business_area_id, v.name, i.INSTANCE_DESCRIPTION, t.ANALYSIS_CYCLE_ID
1583: into l_taskName, l_BAID, l_BA_name, l_BP_runName, l_BP_runID
1584: from zpb_analysis_cycles ac, zpb_analysis_cycle_tasks t,
1585: ZPB_BUSINESS_AREAS_VL v, zpb_analysis_cycle_instances i
1586: where t.task_id = l_taskID
1587: and t.ANALYSIS_CYCLE_ID = ac.ANALYSIS_CYCLE_ID
1588: and ac.ANALYSIS_CYCLE_ID = i.INSTANCE_AC_ID
1589: and ac.business_area_id = v.business_area_id;