APPS.ZPB_WF_NTF dependencies on ZPB_AC_PARAM_VALUES

Line 720: where v.analysis_cycle_id in (select pa.analysis_cycle_id from zpb_ac_param_values pa

716: CURSOR c_eventACID is
717: select distinct v.analysis_cycle_id thisACID, v.name thisACName,
718: u.user_name thisUser
719: from zpb_all_cycles_v v, zpb_process_details_v pro, fnd_user u
720: where v.analysis_cycle_id in (select pa.analysis_cycle_id from zpb_ac_param_values pa
721: where pa.param_id = 20 and pa.value in(select d.value from ZPB_PROCESS_DETAILS_V d
722: where d.name = 'CREATE_EVENT_IDENTIFIER' and d.task_id = TaskID))
723: and v.last_updated_by = u.user_id;
724: