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.PER_SPH_BUS dependencies on PER_SP_PLAN

Line 31: , per_sp_plan spp

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_sp_plan spp
32: where spp.plan_id = p_plan_id
33: and pbg.business_group_id = spp.business_group_id;
34: --
35: -- Declare local variables

Line 101: , per_sp_plan spp

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_sp_plan spp
102: where spp.plan_id = p_plan_id
103: and pbg.business_group_id = spp.business_group_id;
104: --
105: -- Declare local variables

Line 435: from per_sp_plan

431:
432: hr_utility.set_location('l_max_plans :'||l_max_plans, 40);
433:
434: select count(*) into l_plan_count
435: from per_sp_plan
436: where successee_id=p_successee_id
437: and plan_type=p_successee_type
438: and status='A';
439: