DBA Data[Home] [Help]

APPS.BEN_EGN_BUS dependencies on BEN_ELIG_GNDR_PRTE_F

Line 116: from ben_elig_gndr_prte_f egn

112: l_dummy char(1);
113: --
114: cursor c_elig_gndr_prte is
115: select null
116: from ben_elig_gndr_prte_f egn
117: where egn.eligy_prfl_id = p_eligy_prfl_id
118: and egn.sex = p_sex
119: and egn.ELIG_GNDR_PRTE_id <> nvl(p_ELIG_GNDR_PRTE_id, hr_api.g_number) ;
120: --

Line 260: from ben_ELIG_GNDR_PRTE_f

256: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
257: l_dummy char(1);
258: cursor c1 is
259: select null
260: from ben_ELIG_GNDR_PRTE_f
261: where ELIG_GNDR_PRTE_id <> nvl(p_ELIG_GNDR_PRTE_id,-1)
262: and eligy_prfl_id = p_eligy_prfl_id
263: and ordr_num = p_ordr_num
264: and business_group_id = p_business_group_id;

Line 705: ben_ELIG_GNDR_PRTE_f b

701: --
702: cursor csr_leg_code is
703: select a.legislation_code
704: from per_business_groups a,
705: ben_ELIG_GNDR_PRTE_f b
706: where b.ELIG_GNDR_PRTE_id = p_ELIG_GNDR_PRTE_id
707: and a.business_group_id = b.business_group_id;
708: --
709: -- Declare local variables