APPS.GHR_PAR_BUS dependencies on PER_ALL_PEOPLE_F

Line 242: FROM per_all_people_f per

238:
239: --
240: cursor cur_per_id is
241: SELECT 1
242: FROM per_all_people_f per
243: where per.person_id = p_val_person_id;
244:
245: cursor cur_per_dt_id is
246: SELECT 1

Line 247: FROM per_all_people_f per

243: where per.person_id = p_val_person_id;
244:
245: cursor cur_per_dt_id is
246: SELECT 1
247: FROM per_all_people_f per
248: WHERE per.person_id = p_val_person_id
249: AND nvl(p_effective_date,sysdate)
250: BETWEEN per.effective_start_date and per.effective_end_date;
251: --

Line 505: from per_all_people_f ppf,

501: --
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

Line 681: l_person_id per_all_people_f.person_id%type;

677: ) is
678: --
679: l_proc varchar2(72) := g_package||'chk_employee_assignment_id';
680: l_exists boolean := false;
681: l_person_id per_all_people_f.person_id%type;
682: l_api_updating boolean;
683: l_effective_date date;
684: l_st_date date;
685: l_ed_date date;

Line 707: from per_all_people_f ppf,

703: --7015822
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