APPS.ZPB_EXCEPTION_ALERT dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 292: from zpb_analysis_cycle_tasks

288: aname => 'INSTANCEID');
289:
290: -- set up defaults for author and type
291: select TASK_NAME into TaskName
292: from zpb_analysis_cycle_tasks
293: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
294:
295:
296: -- bug 3482485

Line 401: from zpb_analysis_cycle_tasks

397:
398: -- set Task Name!
399: select TASK_NAME
400: into TaskName
401: from zpb_analysis_cycle_tasks
402: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
403:
404: wf_engine.SetItemAttrText(Itemtype => ItemType,
405: Itemkey => NEWItemKey,

Line 945: from zpb_analysis_cycle_tasks

941:
942: -- set Task Name!
943: select TASK_NAME
944: into TaskName
945: from zpb_analysis_cycle_tasks
946: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
947:
948: select INSTANCE_DESCRIPTION
949: into InstanceDesc

Line 1626: from zpb_analysis_cycle_tasks

1622:
1623: -- set Task Name!
1624: select TASK_NAME, LAST_UPDATED_BY
1625: into TaskName, thisApproverID
1626: from zpb_analysis_cycle_tasks
1627: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
1628:
1629: select INSTANCE_DESCRIPTION
1630: into InstanceDesc

Line 2655: from zpb_analysis_cycle_tasks

2651: aname => 'INSTANCEID');
2652:
2653: -- set Task Name!
2654: select TASK_NAME into TaskName
2655: from zpb_analysis_cycle_tasks
2656: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
2657:
2658: -- bug 3482485
2659: select value into l_authorIDT

Line 2864: from zpb_analysis_cycle_tasks

2860:
2861: -- set Task Name!
2862: select TASK_NAME, LAST_UPDATED_BY
2863: into TaskName, thisApproverID
2864: from zpb_analysis_cycle_tasks
2865: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
2866:
2867: select INSTANCE_DESCRIPTION
2868: into InstanceDesc