APPS.BEN_EAN_BUS dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 128: from ben_elig_asnt_set_prte_f

124: --
125: --
126: cursor c3 is
127: select null
128: from ben_elig_asnt_set_prte_f
129: where assignment_set_id = p_assignment_set_id
130: and eligy_prfl_id = p_eligy_prfl_id
131: and elig_asnt_set_prte_id <> nvl(p_elig_asnt_set_prte_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id

Line 297: from ben_elig_asnt_set_prte_f

293: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
294: l_dummy char(1);
295: cursor c1 is
296: select null
297: from ben_elig_asnt_set_prte_f
298: where elig_asnt_set_prte_id <> nvl(p_elig_asnt_set_prte_id,-1)
299: and eligy_prfl_id = p_eligy_prfl_id
300: and ordr_num = p_ordr_num
301: and business_group_id = p_business_group_id;

Line 669: ben_elig_asnt_set_prte_f b

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