APPS.ZPB_DC_WF dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 298: l_prior_item_key zpb_analysis_cycle_tasks.item_key%TYPE;

294: l_object_user_id number;
295: l_object_user_name fnd_user.description%TYPE;
296: l_distribute_message zpb_task_parameters.value%TYPE;
297: l_template_name zpb_dc_objects.template_name%TYPE;
298: l_prior_item_key zpb_analysis_cycle_tasks.item_key%TYPE;
299: l_issue_msg fnd_new_messages.message_text%TYPE;
300:
301: l_respapp_id number := 0;
302: l_user_id number := 0;

Line 2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param

2931: -- Find the item key manage submission task that is managing the submissions
2932: -- of this template
2933: SELECT task.item_key
2934: INTO l_item_key
2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param
2936: WHERE obj.object_id = l_object_id
2937: AND task.analysis_cycle_id = obj.ac_instance_id
2938: AND task.task_id = param.task_id
2939: AND param.name = 'SUBMISSION_TEMPLATE_ID'