APPS.ZPB_WF_NTF dependencies on ZPB_PROCESS_DETAILS_V

Line 719: from zpb_all_cycles_v v, zpb_process_details_v pro, fnd_user u

715:
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;

Line 721: where pa.param_id = 20 and pa.value in(select d.value from ZPB_PROCESS_DETAILS_V d

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:
725: -- v_eventACID c_eventACID%ROWTYPE;

Line 730: from zpb_process_details_v

726:
727: BEGIN
728:
729: select task_name into TaskName
730: from zpb_process_details_v
731: where task_id = TaskID and name = 'CREATE_EVENT_IDENTIFIER';
732:
733: ACIDEvent := NULL;
734: FOR each in c_eventACID loop

Line 827: from ZPB_PROCESS_DETAILS_V

823: taskID number;
824:
825: CURSOR c_acid is
826: select TASK_ID, TASK_NAME
827: from ZPB_PROCESS_DETAILS_V
828: where ANALYSIS_CYCLE_ID = numericID AND
829: name = 'CREATE_EVENT_IDENTIFIER';
830:
831: v_acid c_acid%ROWTYPE;