APPS.PER_SIP_BUS dependencies on PER_SP_PLAN

Line 382: per_sp_plan pl

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
386: and pl.status='A';

Line 418: from per_sp_plan

414: l_plan_status varchar2(1);
415:
416: cursor csrPlanStatus is
417: select status
418: from per_sp_plan
419: where plan_id=p_plan_id;
420:
421: --
422: Begin

Line 467: from per_sp_plan pl

463: and trunc(sysdate) between effective_start_date and effective_end_date;
464:
465: cursor csrPlanDtls is
466: select pl.successee_id, pl.plan_type
467: from per_sp_plan pl
468: where pl.plan_id=p_plan_id;
469:
470: cursor csrSuccesseeDtls(p_successee_id number, p_type varchar2) is
471: select dtls.allow_npws, dtls.allow_applicants

Line 586: from per_sp_plan pl

582:
583:
584: cursor csrPlanDtls is
585: select pl.successee_id, pl.plan_type
586: from per_sp_plan pl
587: where pl.plan_id=p_plan_id;
588:
589: cursor csrSuccesseeDtls(p_successee_id number, p_type varchar2) is
590: select dtls.max_successors

Line 662: from per_sp_plan pl

658: and trunc(sysdate) between effective_start_date and effective_end_date;
659:
660: cursor csrPlanDtls is
661: select pl.start_date, pl.end_date
662: from per_sp_plan pl
663: where pl.plan_id=p_plan_id;
664:
665: --
666: Begin