APPS.BEN_EJP_BUS dependencies on BEN_ELIG_JOB_PRTE_F

Line 131: from ben_elig_job_prte_f

127: nvl(a.date_to, p_effective_date);
128: --
129: cursor c3 is
130: select null
131: from ben_elig_job_prte_f
132: where job_id = p_job_id
133: and eligy_prfl_id = p_eligy_prfl_id
134: and elig_job_prte_id <> nvl(p_elig_job_prte_id,hr_api.g_number)
135: and business_group_id + 0 = p_business_group_id

Line 167: ben_ejp_shd.constraint_error('BEN_ELIG_JOB_PRTE_FK2');

163: --
164: -- raise error as FK does not relate to PK in per_jobs
165: -- table.
166: --
167: ben_ejp_shd.constraint_error('BEN_ELIG_JOB_PRTE_FK2');
168: --
169: end if;
170: --
171: close c1;

Line 300: from ben_elig_job_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_job_prte_f
301: where elig_job_prte_id <> nvl(p_elig_job_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 672: ben_elig_job_prte_f b

668: --
669: cursor csr_leg_code is
670: select a.legislation_code
671: from per_business_groups a,
672: ben_elig_job_prte_f b
673: where b.elig_job_prte_id = p_elig_job_prte_id
674: and a.business_group_id = b.business_group_id;
675: --
676: -- Declare local variables