APPS.IEU_WORKPANEL_PVT dependencies on IEU_UWQ_NODE_DS

Line 140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds

136:
137: select count(b.maction_def_id) into l_act_usr_lbl_count
138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
141: where e. sel_enum_id = rec_obj.enum_id
142: --and e.application_id = m.application_id
143: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
144: and b.maction_def_id = tl.maction_def_id

Line 161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds

157:
158: select count(b.maction_def_id) into l_set_id_count
159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
162: where e. sel_enum_id = rec_obj.enum_id
163: --and e.application_id = m.application_id
164: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
165: and b.maction_def_id = tl.maction_def_id

Line 417: IEU_UWQ_NODE_DS ds

413:
414: select count(b.maction_def_id) into l_act_usr_lbl_count
415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,
417: IEU_UWQ_NODE_DS ds
418: where e. sel_enum_id = p_enum_id
419: --and e.application_id = m.application_id
420: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
421: and b.maction_def_id = tl.maction_def_id

Line 438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds

434:
435:
436: select count(b.maction_def_id) into l_set_id_count
437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds
439: where e. sel_enum_id = p_enum_id
440: --and e.application_id = m.application_id
441: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
442: and b.maction_def_id = tl.maction_def_id

Line 1284: (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds

1280: DELETE FROM ieu_wp_action_maps
1281: WHERE action_param_set_id = x_param_set_id AND
1282: action_map_type_code = 'NODE_DS' AND
1283: action_map_code IN
1284: (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds
1285: WHERE e.sel_enum_id = x_node_id
1286: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID);
1287:
1288: end if;