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_BNG_BUS dependencies on PER_ALL_PEOPLE_F

Line 134: -- per_all_people_f table when the user deletes the record in the ben_

130: -- -------------------------------------------------------------------------
131: --
132: -- Description
133: -- This procedure is used to check that benefit groups do not exist in the
134: -- per_all_people_f table when the user deletes the record in the ben_
135: -- bnfts_grp table.
136: --
137: -- Pre Conditions
138: -- None.

Line 159: from per_all_people_f per

155: l_proc varchar2(72):= g_package||'chk_child_records';
156: v_dummy varchar2(1);
157: --
158: cursor chk_benefits_group is select null
159: from per_all_people_f per
160: where per.benefit_group_id = p_benfts_grp_id
161: and per.business_Group_id= p_business_group_id; /* Perf Bug 4882374 */
162: begin
163: --

Line 166: -- check if benefit groups exists in the per_all_people_f table

162: begin
163: --
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: -- check if benefit groups exists in the per_all_people_f table
167: --
168: open chk_benefits_group;
169: --
170: -- fetch value from cursor if it returns a record then the