APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_ACTION_PARAMS

Line 382: FROM ieu_wp_action_params

378: select param_id
379: from ieu_wp_param_defs_b
380: where param_name = LTRIM(RTRIM(r_param_name))
381: AND param_id IN (SELECT param_id
382: FROM ieu_wp_action_params
383: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
384: FROM ieu_uwq_maction_defs_b
385: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
386: )

Line 395: FROM ieu_wp_action_params

391: from ieu_wp_param_props_b a, ieu_wp_param_defs_b b
392: where a.param_id = b.param_id
393: and b.param_name = LTRIM(RTRIM(r_param_name))
394: AND a.param_id IN (SELECT param_id
395: FROM ieu_wp_action_params
396: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
397: FROM ieu_uwq_maction_defs_b
398: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
399: )

Line 404: from ieu_wp_action_params a, ieu_wp_param_defs_b b

400: );
401:
402: cursor c_cursor2 is
403: select a.ACTION_PARAM_MAP_ID
404: from ieu_wp_action_params a, ieu_wp_param_defs_b b
405: where a.param_id = b.param_id
406: and b.param_name = LTRIM(RTRIM(r_param_name))
407: AND a.param_id IN (SELECT param_id
408: FROM ieu_wp_action_params

Line 408: FROM ieu_wp_action_params

404: from ieu_wp_action_params a, ieu_wp_param_defs_b b
405: where a.param_id = b.param_id
406: and b.param_name = LTRIM(RTRIM(r_param_name))
407: AND a.param_id IN (SELECT param_id
408: FROM ieu_wp_action_params
409: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
410: FROM ieu_uwq_maction_defs_b
411: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
412: )

Line 434: delete from ieu_wp_action_params where ACTION_PARAM_MAP_ID= cur_rec.ACTION_PARAM_MAP_ID;

430:
431: end LOOP;
432: FOR cur_rec IN c_cursor2
433: LOOP
434: delete from ieu_wp_action_params where ACTION_PARAM_MAP_ID= cur_rec.ACTION_PARAM_MAP_ID;
435: end LOOP;
436:
437: FOR cur_rec IN c_cursor
438: LOOP