APPS.BEN_EOY_BUS dependencies on BEN_ELIG_OTHR_PTIP_PRTE_F

Line 129: from ben_elig_othr_ptip_prte_f eoy

125: between ctp.effective_start_date and ctp.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_elig_othr_ptip_prte_f eoy
130: where eoy.ptip_id = p_ptip_id
131: and eoy.eligy_prfl_id = p_eligy_prfl_id
132: and eoy.elig_othr_ptip_prte_id <> nvl(p_elig_othr_ptip_prte_id,hr_api.g_number)
133:

Line 369: from ben_elig_othr_ptip_prte_f

365: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
366: l_dummy char(1);
367: cursor c1 is
368: select null
369: from ben_elig_othr_ptip_prte_f
370: where elig_othr_ptip_prte_id <> nvl(p_elig_othr_ptip_prte_id,-1)
371: and eligy_prfl_id = p_eligy_prfl_id
372: and ordr_num = p_ordr_num
373: and business_group_id = p_business_group_id;

Line 762: ben_elig_othr_ptip_prte_f b

758: --
759: cursor csr_leg_code is
760: select a.legislation_code
761: from per_business_groups a,
762: ben_elig_othr_ptip_prte_f b
763: where b.elig_othr_ptip_prte_id = p_elig_othr_ptip_prte_id
764: and a.business_group_id = b.business_group_id;
765: --
766: -- Declare local variables