eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EJP_BUS dependencies on PER_JOBS

Line 123: from per_jobs a

119: l_exists varchar2(1);
120: --
121: cursor c1 is
122: select null
123: from per_jobs a
124: where a.job_id = p_job_id
125: and a.business_group_id + 0 = p_business_group_id
126: and p_effective_date between a.date_from and
127: nvl(a.date_to, p_effective_date);

Line 155: -- check if job_id value exists in per_jobs table

151: and nvl(p_job_id,hr_api.g_number)
152: <> nvl(ben_ejp_shd.g_old_rec.job_id,hr_api.g_number)
153: or not l_api_updating) then
154: --
155: -- check if job_id value exists in per_jobs table
156: --
157: open c1;
158: --
159: fetch c1 into l_dummy;

Line 164: -- raise error as FK does not relate to PK in per_jobs

160: if c1%notfound then
161: --
162: close c1;
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: --