DBA Data[Home] [Help]

APPS.PER_SIP_BUS dependencies on PER_SP_SUCCESSEE_DETAILS

Line 472: from per_sp_successee_details dtls

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
472: from per_sp_successee_details dtls
473: where dtls.successee_id=p_successee_id
474: and dtls.successee_type=p_type;
475:
476: cursor csrPersonType is

Line 591: from per_sp_successee_details dtls

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
591: from per_sp_successee_details dtls
592: where dtls.successee_id=p_successee_id
593: and dtls.successee_type=p_type;
594:
595: --