APPS.PER_SIP_BUS dependencies on PER_SP_SUCCESSOR_IN_PLAN

Line 31: , per_sp_successor_in_plan sip

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_successor_in_plan sip
32: where sip.successor_in_plan_id = p_successor_in_plan_id
33: and pbg.business_group_id = sip.business_group_id;
34: --
35: -- Declare local variables

Line 101: , per_sp_successor_in_plan sip

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_sp_successor_in_plan sip
102: where sip.successor_in_plan_id = p_successor_in_plan_id
103: and pbg.business_group_id = sip.business_group_id;
104: --
105: -- Declare local variables

Line 381: from per_sp_successor_in_plan scsr,

377:
378: hr_utility.set_location('l_max_plans :'||l_max_plans, 40);
379:
380: select count(*) into l_plan_count
381: from per_sp_successor_in_plan scsr,
382: per_sp_plan pl
383: where scsr.successor_id=p_successor_id
384: and scsr.status='A'
385: and scsr.plan_id=pl.plan_id

Line 621: FROM per_sp_successor_in_plan

617: end if;
618: close csrSuccesseeDtls;
619:
620: SELECT count (*) into l_scsr_count
621: FROM per_sp_successor_in_plan
622: WHERE plan_id = p_plan_id
623: AND status='A';
624: if l_scsr_count >= l_max_successors
625: then