APPS.BEN_DPNT_EGD_BUS dependencies on BEN_ELIGY_CRITERIA_DPNT

Line 111: from ben_eligy_criteria_dpnt

107: l_dummy char(1);
108:
109: cursor c1 is
110: select null
111: from ben_eligy_criteria_dpnt
112: Where eligy_criteria_dpnt_id <> nvl(p_eligy_criteria_dpnt_id,-1)
113: and name = p_name
114: and business_group_id = p_business_group_id;
115:

Line 169: from ben_eligy_criteria_dpnt

165: l_proc varchar2(72) := g_package||'chk_short_code_unique';
166: l_dummy char(1);
167:
168: cursor c1 is select null
169: from ben_eligy_criteria_dpnt
170: Where eligy_criteria_dpnt_id <> nvl(p_eligy_criteria_dpnt_id,-1)
171: and short_code = p_short_code
172: and business_group_id = p_business_group_id;
173:

Line 1808: ben_eligy_criteria_dpnt b

1804: --
1805: cursor csr_leg_code is
1806: select a.legislation_code
1807: from per_business_groups a,
1808: ben_eligy_criteria_dpnt b
1809: where b.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
1810: and a.business_group_id = b.business_group_id;
1811:
1812: --