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_EGR_BUS dependencies on PER_GRADES

Line 121: from per_grades a

117: l_exists varchar2(1);
118: --
119: cursor c1 is
120: select null
121: from per_grades a
122: where a.grade_id = p_grade_id
123: and a.business_group_id + 0 = p_business_group_id
124: and p_effective_date between a.date_from
125: and nvl(date_to, p_effective_date);

Line 153: -- check if grade_id value exists in per_grades table

149: and nvl(p_grade_id,hr_api.g_number)
150: <> nvl(ben_egr_shd.g_old_rec.grade_id,hr_api.g_number)
151: or not l_api_updating) then
152: --
153: -- check if grade_id value exists in per_grades table
154: --
155: open c1;
156: --
157: fetch c1 into l_dummy;

Line 162: -- raise error as FK does not relate to PK in per_grades

158: if c1%notfound then
159: --
160: close c1;
161: --
162: -- raise error as FK does not relate to PK in per_grades
163: -- table.
164: --
165: ben_egr_shd.constraint_error('BEN_ELIG_GRD_PRTE_FK2');
166: --