DBA Data[Home] [Help]

APPS.BEN_PGM_BUS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 5033: ben_popl_enrt_typ_cycl_f pet

5029: l_dummy varchar2(30);
5030: --
5031: cursor c1 is select null
5032: from ben_lee_rsn_f len,
5033: ben_popl_enrt_typ_cycl_f pet
5034: where pet.pgm_id = p_pgm_id
5035: and len.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
5036: and pet.business_group_id +0 = p_business_group_id
5037: and len.business_group_id +0 = p_business_group_id

Line 6035: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',

6031: l_table_name := 'ben_ptip_f';
6032: Raise l_rows_exist;
6033: End If;
6034: If (dt_api.rows_exist
6035: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',
6036: p_base_key_column => 'pgm_id',
6037: p_base_key_value => p_pgm_id,
6038: p_from_date => p_validation_start_date,
6039: p_to_date => p_validation_end_date)) Then

Line 6040: l_table_name := 'ben_popl_enrt_typ_cycl_f';

6036: p_base_key_column => 'pgm_id',
6037: p_base_key_value => p_pgm_id,
6038: p_from_date => p_validation_start_date,
6039: p_to_date => p_validation_end_date)) Then
6040: l_table_name := 'ben_popl_enrt_typ_cycl_f';
6041: Raise l_rows_exist;
6042: End If;
6043: If (dt_api.rows_exist
6044: (p_base_table_name => 'ben_plip_f',