APPS.BEN_ACTY_VRBL_RATE_API dependencies on BEN_OIPL_F

Line 67: from ben_oipl_f oipl

63: -- Start Option Level Rates
64: --
65: cursor c_oipl(p_opt_id number) is
66: select distinct oipl_id
67: from ben_oipl_f oipl
68: where oipl.opt_id = p_opt_id ;
69: --
70: -- End Option Level Rates
71: --

Line 259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
256: elsif l_c1.ptip_id is not null then
257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
258: elsif l_c1.oipl_id is not null then
259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
260: elsif l_c1.opt_id is not null then
261: --
262: --START Option Level Rates
263: for l_oipl in c_oipl(l_c1.opt_id) loop

Line 264: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl.oipl_id);

260: elsif l_c1.opt_id is not null then
261: --
262: --START Option Level Rates
263: for l_oipl in c_oipl(l_c1.opt_id) loop
264: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl.oipl_id);
265: end loop ;
266: --END Option Level Rates
267: --
268: end if;

Line 626: from ben_oipl_f oipl

622: -- Start Option Level Rates
623: --
624: cursor c_oipl(p_opt_id number) is
625: select distinct oipl_id
626: from ben_oipl_f oipl
627: where oipl.opt_id = p_opt_id
628: and not exists ( select abr.oipl_id
629: from ben_acty_base_rt_f abr
630: where abr.oipl_id = oipl.oipl_id

Line 724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
721: elsif l_c1.ptip_id is not null then
722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
723: elsif l_c1.oipl_id is not null then
724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
725: elsif l_c1.opt_id is not null then
726: --
727: for l_oipl in c_oipl(l_c1.opt_id) loop
728: --

Line 729: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_oipl.oipl_id);

725: elsif l_c1.opt_id is not null then
726: --
727: for l_oipl in c_oipl(l_c1.opt_id) loop
728: --
729: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_oipl.oipl_id);
730: --
731: end loop ;
732: --
733: end if;