APPS.BEN_PLN_BUS dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 858: select null from BEN_CVG_AMT_CALC_MTHD_F cvg

854: l_api_updating boolean;
855: l_dummy varchar2(1);
856: --
857: cursor c1 is
858: select null from BEN_CVG_AMT_CALC_MTHD_F cvg
859: where nvl(cvg.pl_id,-1) = p_pl_id
860: and cvg.cvg_mlt_cd = 'FLFX'
861: and cvg.entr_val_at_enrt_flag = 'Y'
862: and cvg.business_group_id = p_business_group_id

Line 5240: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',

5236: l_table_name := 'ben_prtn_elig_f';
5237: Raise l_rows_exist;
5238: End If;
5239: If (dt_api.rows_exist
5240: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
5241: p_base_key_column => 'pl_id',
5242: p_base_key_value => p_pl_id,
5243: p_from_date => p_validation_start_date,
5244: p_to_date => p_validation_end_date)) Then

Line 5245: l_table_name := 'ben_cvg_amt_calc_mthd_f';

5241: p_base_key_column => 'pl_id',
5242: p_base_key_value => p_pl_id,
5243: p_from_date => p_validation_start_date,
5244: p_to_date => p_validation_end_date)) Then
5245: l_table_name := 'ben_cvg_amt_calc_mthd_f';
5246: Raise l_rows_exist;
5247: End If;
5248: If (dt_api.rows_exist
5249: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',