APPS.BEN_ETP_BUS dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 116: from ben_elig_TTL_PRTT_prte_f

112: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
113: l_dummy char(1);
114: cursor c1 is
115: select null
116: from ben_elig_TTL_PRTT_prte_f
117: where elig_TTL_PRTT_prte_id <> nvl(p_elig_TTL_PRTT_prte_id,-1)
118: and eligy_prfl_id = p_eligy_prfl_id
119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;

Line 1060: ben_ELIG_TTL_PRTT_PRTE_f b

1056: --
1057: cursor csr_leg_code is
1058: select a.legislation_code
1059: from per_business_groups a,
1060: ben_ELIG_TTL_PRTT_PRTE_f b
1061: where b.ELIG_TTL_PRTT_PRTE_id = p_ELIG_TTL_PRTT_PRTE_id
1062: and a.business_group_id = b.business_group_id;
1063: --
1064: -- Declare local variables