APPS.BEN_ECP_BUS dependencies on BEN_ELIG_CMBN_AGE_LOS_PRTE_F

Line 121: from ben_elig_cmbn_age_los_prte_f

117: l_exists varchar2(1);
118: --
119: cursor c3 is
120: select null
121: from ben_elig_cmbn_age_los_prte_f
122: where cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_cmbn_age_los_prte_id <> nvl(p_elig_cmbn_age_los_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id

Line 364: from ben_elig_cmbn_age_los_prte_f

360: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
361: l_dummy char(1);
362: cursor c1 is
363: select null
364: from ben_elig_cmbn_age_los_prte_f
365: where elig_cmbn_age_los_prte_id <> nvl(p_elig_cmbn_age_los_prte_id,-1)
366: and eligy_prfl_id = p_eligy_prfl_id
367: and ordr_num = p_ordr_num
368: and business_group_id = p_business_group_id;

Line 745: ben_elig_cmbn_age_los_prte_f b

741: --
742: cursor csr_leg_code is
743: select a.legislation_code
744: from per_business_groups a,
745: ben_elig_cmbn_age_los_prte_f b
746: where b.elig_cmbn_age_los_prte_id = p_elig_cmbn_age_los_prte_id
747: and a.business_group_id = b.business_group_id;
748: --
749: -- Declare local variables