APPS.BEN_PLN_INS dependencies on BEN_PL_TYP_F

Line 623: from ben_pl_typ_f

619: from sys.dual;
620: --
621: cursor c_pln_typ_opt_typ_cd is
622: select opt_typ_cd
623: from ben_pl_typ_f
624: where pl_typ_id = p_rec.pl_typ_id
625: and business_group_id = p_rec.business_group_id
626: and p_effective_date
627: between effective_start_date

Line 631: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;

627: between effective_start_date
628: and effective_end_date
629: ;
630:
631: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --

Line 1057: p_parent_table_name3 => 'ben_pl_typ_f',

1053: p_parent_key_value1 => p_rec.rt_end_dt_rl,
1054: p_parent_table_name2 => 'ff_formulas_f',
1055: p_parent_key_column2 => 'formula_id',
1056: p_parent_key_value2 => p_rec.rt_strt_dt_rl,
1057: p_parent_table_name3 => 'ben_pl_typ_f',
1058: p_parent_key_column3 => 'pl_typ_id',
1059: p_parent_key_value3 => p_rec.pl_typ_id,
1060: p_parent_table_name4 => 'ff_formulas_f',
1061: p_parent_key_column4 => 'formula_id',