APPS.ZPB_WF_NTF dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 66: from zpb_analysis_cycle_tasks where task_id = TaskId);

62:
63: select business_area_id into l_business_area_id
64: from zpb_analysis_cycles
65: where analysis_cycle_id = (select analysis_cycle_id
66: from zpb_analysis_cycle_tasks where task_id = TaskId);
67:
68: wf_engine.SetItemAttrText(Itemtype => ItemType,
69: Itemkey => ItemKey,
70: aname => 'BUSINESSAREAID',

Line 357: from zpb_analysis_cycle_tasks where task_id = TaskId) ;

353:
354:
355: select business_area_id into l_business_area_id from
356: zpb_analysis_cycles where analysis_cycle_id = (select analysis_cycle_id
357: from zpb_analysis_cycle_tasks where task_id = TaskId) ;
358:
359: select INSTANCE_DESCRIPTION
360: into InstDesc
361: from ZPB_ANALYSIS_CYCLE_INSTANCES

Line 620: update ZPB_ANALYSIS_CYCLE_TASKS

616: -- Set the ReviewBP task whose notification action caused the
617: -- instance to be paused to complete
618: -- This is normally done in RunNextTask procedure, but this task
619: -- never calls that procedure
620: update ZPB_ANALYSIS_CYCLE_TASKS
621: set status_code = 'COMPLETE'
622: where TASK_ID = TaskID;
623:
624: resultout :='COMPLETE';

Line 1584: from zpb_analysis_cycles ac, zpb_analysis_cycle_tasks t,

1580: l_taskID := p_taskID;
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