APPS.BEN_EBN_BUS dependencies on BEN_ELIG_BENFTS_GRP_PRTE_F

Line 121: from ben_elig_benfts_grp_prte_f

117: l_exists varchar2(1);
118: --
119: cursor c3 is
120: select null
121: from ben_elig_benfts_grp_prte_f
122: where benfts_grp_id = p_benfts_grp_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_benfts_grp_prte_id <> nvl(p_elig_benfts_grp_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id

Line 298: from ben_elig_benfts_grp_prte_f

294: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
295: l_dummy char(1);
296: cursor c1 is
297: select null
298: from ben_elig_benfts_grp_prte_f
299: where elig_benfts_grp_prte_id <> nvl(p_elig_benfts_grp_prte_id,-1)
300: and eligy_prfl_id = p_eligy_prfl_id
301: and ordr_num = p_ordr_num
302: and business_group_id = p_business_group_id;

Line 666: ben_elig_benfts_grp_prte_f b

662: --
663: cursor csr_leg_code is
664: select a.legislation_code
665: from per_business_groups a,
666: ben_elig_benfts_grp_prte_f b
667: where b.elig_benfts_grp_prte_id = p_elig_benfts_grp_prte_id
668: and a.business_group_id = b.business_group_id;
669: --
670: -- Declare local variables