APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BEN_CWB_PL_DSGN

Line 27: select name || ' - ' from ben_cwb_pl_dsgn

23: l_step varchar2(100);
24: l_plan_name varchar2(100);
25: l_created varchar2(1) := 'N';
26: cursor c_plan_name is
27: select name || ' - ' from ben_cwb_pl_dsgn
28: where pl_id = p_group_pl_id and pl_id = group_pl_id
29: and oipl_id = -1 and group_oipl_id = -1;
30:
31: cursor c_bne_integrators is

Line 722: update ben_cwb_pl_dsgn set custom_integrator = l_new_integrator_code

718: END LOOP; -- secured objects.
719:
720: END LOOP; -- integrator
721:
722: update ben_cwb_pl_dsgn set custom_integrator = l_new_integrator_code
723: where pl_id = p_group_pl_id and pl_id = group_pl_id
724: and oipl_id = -1 and group_oipl_id = -1;
725:
726: --COMMIT;