APPS.BEN_ABR_BUS dependencies on BEN_PL_TYP_F

Line 180: from ben_pl_typ_f ptp,

176: l_oipl c_oipl%rowtype;
177: --
178: cursor c_pl_typ(p_pl_id number) is
179: select opt_typ_cd
180: from ben_pl_typ_f ptp,
181: ben_pl_f pln
182: where pln.pl_id = p_pl_id
183: and ptp.pl_typ_id = pln.pl_typ_id;
184: --

Line 185: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;

181: ben_pl_f pln
182: where pln.pl_id = p_pl_id
183: and ptp.pl_typ_id = pln.pl_typ_id;
184: --
185: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;
186: --
187: cursor c1 is
188: select null
189: from ben_acty_base_rt_f abr

Line 195: select pl_id from ben_pl_f pln, ben_pl_typ_f typ

191: and abr.acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
192: and abr.business_group_id = p_business_group_id
193: and p_effective_date between abr.effective_start_date and abr.effective_end_date
194: and abr.pl_id IN (
195: select pl_id from ben_pl_f pln, ben_pl_typ_f typ
196: where typ.opt_typ_cd ='ICM'
197: and typ.pl_typ_id = pln.pl_typ_id
198: and pln.pl_typ_id IN (
199: select pl_typ_id from ben_pl_f where pl_id IN

Line 782: from ben_pl_typ_f ptp,

778: l_oipl c_oipl%rowtype;
779: --
780: cursor c_pl_typ(p_pl_id number) is
781: select nvl(opt_typ_cd,'ZZZ') --Bug 7042738
782: from ben_pl_typ_f ptp,
783: ben_pl_f pln
784: where pln.pl_id = p_pl_id
785: and ptp.pl_typ_id = pln.pl_typ_id;
786: --

Line 787: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE := 'ZZZ'; --Bug 7042738

783: ben_pl_f pln
784: where pln.pl_id = p_pl_id
785: and ptp.pl_typ_id = pln.pl_typ_id;
786: --
787: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE := 'ZZZ'; --Bug 7042738
788: --ICM Changes
789: --
790: begin
791: --

Line 2554: from BEN_PL_TYP_F

2550: and p_effective_start_date between effective_start_date and effective_end_date;
2551: --
2552: cursor chk_opt_usg_pltyp is
2553: select null
2554: from BEN_PL_TYP_F
2555: where PL_TYP_ID in (select pl_typ_id
2556: from BEN_PL_TYP_OPT_TYP_F
2557: where opt_id = p_opt_id
2558: and business_group_id = p_business_group_id

Line 2566: from BEN_PL_TYP_F

2562: and business_group_id = p_business_group_id;
2563: --
2564: cursor chk_opt_usg_pl(p_pl_id number) is
2565: select null
2566: from BEN_PL_TYP_F
2567: where PL_TYP_ID = (select pl_typ_id from ben_pl_f
2568: where pl_id = p_pl_id
2569: and business_group_id = p_business_group_id
2570: and p_effective_start_date between effective_start_date and effective_end_date)