DBA Data[Home] [Help]

APPS.BEN_PLN_BUS dependencies on BEN_PLIP_F

Line 4664: ben_prtn_eligy_rl_f cer, ben_plip_f plip

4660: --
4661: cursor c2 is
4662: select null
4663: from ben_prtn_elig_f epa, ben_prtn_elig_prfl_f cep,
4664: ben_prtn_eligy_rl_f cer, ben_plip_f plip
4665: where plip.pl_id = p_pl_id
4666: and epa.plip_id = plip.plip_id
4667: and p_effective_date between plip.effective_start_date and plip.effective_end_date
4668: and ((p_validation_start_date <= cep.effective_end_date

Line 5204: (p_base_table_name => 'ben_plip_f',

5200: l_table_name := 'ben_pl_gd_or_svc_f';
5201: Raise l_rows_exist;
5202: End If;
5203: If (dt_api.rows_exist
5204: (p_base_table_name => 'ben_plip_f',
5205: p_base_key_column => 'pl_id',
5206: p_base_key_value => p_pl_id,
5207: p_from_date => p_validation_start_date,
5208: p_to_date => p_validation_end_date)) Then

Line 5209: l_table_name := 'ben_plip_f';

5205: p_base_key_column => 'pl_id',
5206: p_base_key_value => p_pl_id,
5207: p_from_date => p_validation_start_date,
5208: p_to_date => p_validation_end_date)) Then
5209: l_table_name := 'ben_plip_f';
5210: Raise l_rows_exist;
5211: End If;
5212: If (dt_api.rows_exist
5213: (p_base_table_name => 'ben_pl_regn_f',