APPS.BEN_PLN_INS dependencies on BEN_PL_TYP_F

Line 627: from ben_pl_typ_f

623: from sys.dual;
624: --
625: cursor c_pln_typ_opt_typ_cd is
626: select opt_typ_cd
627: from ben_pl_typ_f
628: where pl_typ_id = p_rec.pl_typ_id
629: and business_group_id = p_rec.business_group_id
630: and p_effective_date
631: between effective_start_date

Line 635: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

631: between effective_start_date
632: and effective_end_date
633: ;
634:
635: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
636: --
637: Begin
638: hr_utility.set_location('Entering:'||l_proc, 5);
639: --

Line 1062: p_parent_table_name3 => 'ben_pl_typ_f',

1058: p_parent_key_value1 => p_rec.rt_end_dt_rl,
1059: p_parent_table_name2 => 'ff_formulas_f',
1060: p_parent_key_column2 => 'formula_id',
1061: p_parent_key_value2 => p_rec.rt_strt_dt_rl,
1062: p_parent_table_name3 => 'ben_pl_typ_f',
1063: p_parent_key_column3 => 'pl_typ_id',
1064: p_parent_key_value3 => p_rec.pl_typ_id,
1065: p_parent_table_name4 => 'ff_formulas_f',
1066: p_parent_key_column4 => 'formula_id',