APPS.BEN_ESA_BUS dependencies on BEN_ELIG_SVC_AREA_PRTE_F

Line 192: from ben_elig_svc_area_prte_f esa

188: l_dummy char(1);
189: --
190: cursor c_elig_svc_area_prte is
191: select null
192: from ben_elig_svc_area_prte_f esa
193: where esa.eligy_prfl_id = p_eligy_prfl_id
194: and esa.svc_area_id = p_svc_area_id
195: and esa.ELIG_SVC_AREA_PRTE_ID <> nvl(p_elig_svc_area_prte_id, hr_api.g_number)
196: and esa.business_group_id= p_business_group_id

Line 269: from ben_elig_svc_area_prte_f esa

265: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
266: l_dummy char(1);
267: cursor c1 is
268: select null
269: from ben_elig_svc_area_prte_f esa
270: where esa.elig_svc_area_prte_id <> nvl(p_elig_svc_area_prte_id,-1)
271: and esa.eligy_prfl_id = p_eligy_prfl_id
272: and esa.ordr_num = p_ordr_num
273: and esa.business_group_id = p_business_group_id

Line 656: ben_elig_svc_area_prte_f b

652: --
653: cursor csr_leg_code is
654: select a.legislation_code
655: from per_business_groups a,
656: ben_elig_svc_area_prte_f b
657: where b.elig_svc_area_prte_id = p_elig_svc_area_prte_id
658: and a.business_group_id = b.business_group_id;
659: --
660: -- Declare local variables