DBA Data[Home] [Help]

APPS.BEN_LBR_BUS dependencies on BEN_PL_F

Line 778: ,ben_pl_f pln

774: cursor c2 is
775: select null
776: from ben_cvg_amt_calc_mthd_f cvg
777: ,ben_plip_f cpp
778: ,ben_pl_f pln
779: where cvg.cvg_mlt_cd = 'FLFX'
780: and cvg.entr_val_at_enrt_flag = 'Y'
781: and p_plip_id = cpp.plip_id
782: and nvl(cvg.pl_id,-1) = cpp.pl_id

Line 934: (p_base_table_name => 'ben_pl_f',

930: Raise l_integrity_error;
931: End If;
932: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
933: NOT (dt_api.check_min_max_dates
934: (p_base_table_name => 'ben_pl_f',
935: p_base_key_column => 'pl_id',
936: p_base_key_value => p_pl_id,
937: p_from_date => p_validation_start_date,
938: p_to_date => p_validation_end_date))) Then

Line 939: l_table_name := 'ben_pl_f';

935: p_base_key_column => 'pl_id',
936: p_base_key_value => p_pl_id,
937: p_from_date => p_validation_start_date,
938: p_to_date => p_validation_end_date))) Then
939: l_table_name := 'ben_pl_f';
940: Raise l_integrity_error;
941: End If;
942: --
943: End If;