APPS.BEN_EOU_BUS dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 200: from ben_elig_org_unit_prte_f

196: --
197: --
198: cursor c3 is
199: select null
200: from ben_elig_org_unit_prte_f
201: where organization_id = p_organization_id
202: and eligy_prfl_id = p_eligy_prfl_id
203: and elig_org_unit_prte_id <> nvl(p_elig_org_unit_prte_id,hr_api.g_number)
204: and business_group_id + 0 = p_business_group_id

Line 300: from ben_elig_org_unit_prte_f

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

Line 669: ben_elig_org_unit_prte_f b

665: --
666: cursor csr_leg_code is
667: select a.legislation_code
668: from per_business_groups a,
669: ben_elig_org_unit_prte_f b
670: where b.elig_org_unit_prte_id = p_elig_org_unit_prte_id
671: and a.business_group_id = b.business_group_id;
672: --
673: -- Declare local variables