APPS.BEN_PLN_BUS dependencies on BEN_PL_TYP_F

Line 139: from ben_pl_typ_f ptp

135: and ( bnr.business_group_id = p_business_group_id or p_business_group_id is null);
136: --
137: cursor c_get_ptp_opt_typ_cd (p_pl_typ_id in number) is
138: select opt_typ_cd
139: from ben_pl_typ_f ptp
140: where ptp.pl_typ_id = p_pl_typ_id
141: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;
142: --
143:

Line 266: from ben_pl_typ_f plt,

262:
263:
264: cursor c_pl_cwb is
265: select plt.opt_typ_cd
266: from ben_pl_typ_f plt,
267: ben_pl_f pl
268: where pl.pl_id = p_pl_id
269: and plt.pl_typ_id = pl.pl_typ_id
270: and p_effective_date between plt.effective_start_date

Line 284: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

280: and effective_end_date > p_effective_date
281: ;
282: -- dont validate the date
283: l_dummy varchar2(1) ;
284: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
285: l_proc varchar2(72) := g_package||'chk_pl_group_child';
286:
287: Begin
288:

Line 336: from ben_pl_typ_f plt

332:
333:
334: cursor c_pl_cwb is
335: select opt_typ_cd
336: from ben_pl_typ_f plt
337: where plt.pl_typ_id = p_pl_typ_id
338: and plt.opt_typ_cd = 'CWB'
339: and p_effective_date between plt.effective_start_date
340: and plt.effective_end_Date ;

Line 345: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

341:
342:
343:
344: l_dummy varchar2(1) ;
345: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
346:
347: --
348: Begin
349: --

Line 672: from ben_pl_typ_f

668: l_exist_group_pl_id number;
669: --
670: cursor c1 is
671: select opt_typ_cd
672: from ben_pl_typ_f
673: where pl_typ_id = p_pl_typ_id
674: and business_group_id = p_business_group_id
675: and p_effective_date between effective_start_date and effective_end_date;
676: --

Line 679: from ben_pl_f pln, ben_pl_typ_f ptp

675: and p_effective_date between effective_start_date and effective_end_date;
676: --
677: cursor c2 is
678: select null
679: from ben_pl_f pln, ben_pl_typ_f ptp
680: where pln.pl_typ_id = ptp.pl_typ_id
681: and ptp.opt_typ_cd = 'CWB'
682: and pln.pl_id <> nvl(p_pl_id,-1)
683: and pln.name = p_name

Line 690: from ben_pl_f pln, ben_pl_typ_f ptp

686: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;
687: --
688: cursor c3 is
689: select null
690: from ben_pl_f pln, ben_pl_typ_f ptp
691: where pln.pl_typ_id = ptp.pl_typ_id
692: and ptp.opt_typ_cd = 'CWB'
693: and pln.pl_id <> nvl(p_pl_id,-1)
694: and pln.name = p_name

Line 4554: from ben_pl_typ_f

4550: l_comp_typ_cd varchar2(30);
4551: --
4552: cursor c_pln_typ_opt_typ_cd is
4553: select opt_typ_cd ,comp_typ_cd
4554: from ben_pl_typ_f
4555: where pl_typ_id = p_pl_typ_id
4556: and business_group_id = p_business_group_id
4557: and p_effective_date
4558: between effective_start_date

Line 4924: (p_base_table_name => 'ben_pl_typ_f',

4920: Raise l_integrity_error;
4921: End If;
4922: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4923: NOT (dt_api.check_min_max_dates
4924: (p_base_table_name => 'ben_pl_typ_f',
4925: p_base_key_column => 'pl_typ_id',
4926: p_base_key_value => p_pl_typ_id,
4927: p_from_date => p_validation_start_date,
4928: p_to_date => p_validation_end_date))) Then

Line 4929: l_table_name := 'ben_pl_typ_f';

4925: p_base_key_column => 'pl_typ_id',
4926: p_base_key_value => p_pl_typ_id,
4927: p_from_date => p_validation_start_date,
4928: p_to_date => p_validation_end_date))) Then
4929: l_table_name := 'ben_pl_typ_f';
4930: Raise l_integrity_error;
4931: End If;
4932: --
4933: