APPS.GHR_PAR_BUS dependencies on PER_PERSON_TYPES

Line 499: l_person_type per_person_types.system_person_type%type := Null;

495:
496: l_exists varchar2(15);
497: l_proc varchar2(72) := g_package ||'chk_person_id';
498: l_api_updating boolean;
499: l_person_type per_person_types.system_person_type%type := Null;
500: l_effective_start_date date := null;
501: --
502: cursor c_person_type_rec is
503: select ppf.effective_start_date,

Line 506: per_person_types ppt

502: cursor c_person_type_rec is
503: select ppf.effective_start_date,
504: ppt.system_person_type
505: from per_all_people_f ppf,
506: per_person_types ppt
507: where ppf.person_id = p_person_id
508: and ppf.effective_start_date < nvl(p_effective_date,sysdate)
509: and ppt.person_type_id = ppf.person_type_id
510: order by 1 desc;

Line 708: per_person_types ppt

704: cursor cur_ex_emp(p_person_id in number) is
705: select ppf.effective_start_date,
706: ppt.system_person_type
707: from per_all_people_f ppf,
708: per_person_types ppt
709: where ppf.person_id = p_person_id
710: and ppf.effective_start_date <= nvl(p_effective_date,sysdate)
711: and ppt.person_type_id = ppf.person_type_id
712: order by 1 desc;