APPS.AHL_WF_MAPPING_PVT dependencies on WF_RUNNABLE_PROCESSES_V

Line 267: from WF_RUNNABLE_PROCESSES_V

263:
264: -- To retrieve item type for the entered process name not selected from LOV's
265: /*cursor c_item_type Is
266: select ITEM_TYPE
267: from WF_RUNNABLE_PROCESSES_V
268: where PROCESS_NAME = p_wf_mapping_rec.WF_PROCESS_NAME;
269: */
270:
271: CURSOR c_appl_usg IS

Line 514: from WF_RUNNABLE_PROCESSES_V

510:
511: -- To retrieve item type for the entered process name not selected from LOV's
512: cursor c_item_type Is
513: select ITEM_TYPE
514: from WF_RUNNABLE_PROCESSES_V
515: where PROCESS_NAME = p_wf_mapping_rec.WF_PROCESS_NAME;
516:
517: CURSOR c_appl_usg IS
518: SELECT LOOKUP_CODE

Line 699: -- Check process name if present in WF_RUNNABLE_PROCESSES_V view or

695:
696: --------------------------------------------------------------------
697: -- PROCEDURE
698: -- Check_Process_Name
699: -- Check process name if present in WF_RUNNABLE_PROCESSES_V view or
700: -- raise an error message
701: --------------------------------------------------------------------
702:
703: PROCEDURE Check_Process_Name(

Line 714: select item_type, process_name from WF_RUNNABLE_PROCESSES_V

710: l_count number;
711: cursor cur_process_name Is
712: -- SATHAPLI::Bug# 4919061 fix::SQL Id 14401778
713: /*
714: select item_type, process_name from WF_RUNNABLE_PROCESSES_V
715: where UPPER(display_name) = UPPER(p_wf_mapping_rec.wf_display_name);
716: */
717: SELECT /* PARALLEL (B) +*/
718: B.ITEM_TYPE item_type,

Line 736: select item_type, process_name from wf_runnable_processes_v

732: */
733: AND UPPER(T.NAME) = UPPER(p_wf_mapping_rec.wf_process_name);
734:
735: cursor cur_process_name_type is
736: select item_type, process_name from wf_runnable_processes_v
737: -- SATHAPLI::Bug# 5359954 fix
738: /*
739: where UPPER(display_name) = UPPER(p_wf_mapping_rec.wf_display_name)
740: */