APPS.ZPB_WF_NTF dependencies on ZPB_ANALYSIS_CYCLES

Line 64: from zpb_analysis_cycles

60: Itemkey => ItemKey,
61: aname => '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,

Line 311: from zpb_analysis_cycles A,

307:
308: -- B4951035 - ACID was hard coded to 8891.
309: CURSOR c_bpowner is
310: select C.USER_NAME
311: from zpb_analysis_cycles A,
312: FND_USER C
313: where analysis_cycle_id = ACID AND
314: C.USER_ID = A.OWNER_ID ;
315:

Line 356: zpb_analysis_cycles where analysis_cycle_id = (select analysis_cycle_id

352: thisOwner := zpb_wf_ntf.ID_to_FNDUser(thisOwnerID);
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

Line 607: update ZPB_ANALYSIS_CYCLES

603: -- Itemkey => ItemKey,
604: -- aname => 'FNDUSERNAM');
605:
606: -- first save the current status code in previous status code field
607: update ZPB_ANALYSIS_CYCLES
608: set prev_status_code = status_code
609: where ANALYSIS_CYCLE_ID = InstanceID;
610:
611: -- then update status_code to PAUSED

Line 612: update ZPB_ANALYSIS_CYCLES

608: set prev_status_code = status_code
609: where ANALYSIS_CYCLE_ID = InstanceID;
610:
611: -- then update status_code to PAUSED
612: update ZPB_ANALYSIS_CYCLES
613: set status_code = 'PAUSED'
614: where ANALYSIS_CYCLE_ID = InstanceID;
615:
616: -- Set the ReviewBP task whose notification action caused the

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