DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on PER_ALL_PEOPLE_F

Line 202: FROM per_all_people_f per

198: ,p_effective_date IN DATE
199: ,p_sex OUT NOCOPY VARCHAR2) IS
200: CURSOR cur_per_sex IS
201: SELECT per.sex
202: FROM per_all_people_f per
203: WHERE per.person_id = p_person_id
204: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date;
205: BEGIN
206: FOR cur_per_sex_rec IN cur_per_sex LOOP

Line 362: FROM per_all_people_f per -- Bug 4349372

358: l_special_info ghr_api.special_information_type;
359: l_emp_number per_people_f.employee_number%TYPE;
360: CURSOR c_per IS
361: SELECT per.employee_number
362: FROM per_all_people_f per -- Bug 4349372
363: WHERE per.person_id = p_person_id
364: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
365: AND per.effective_end_date;
366: BEGIN

Line 2315: -- Bug 4349372 changed per_people_f to per_all_people_f.

2311:
2312: -- 24-OCT-2002 JH truncated sf50_approval_date because it does contain time on the db.
2313: -- which causes some rows to not be included on last day.
2314:
2315: -- Bug 4349372 changed per_people_f to per_all_people_f.
2316:
2317: CURSOR cur_get_pars IS
2318: SELECT par.*
2319: FROM ghr_pa_requests par,

Line 2320: per_all_people_f per

2316:
2317: CURSOR cur_get_pars IS
2318: SELECT par.*
2319: FROM ghr_pa_requests par,
2320: per_all_people_f per
2321: WHERE NVL(par.agency_code,par.from_agency_code) LIKE p_agency
2322: AND par.person_id = per.person_id
2323: AND trunc(par.sf50_approval_date) BETWEEN per.effective_start_date
2324: AND per.effective_end_date

Line 2374: CURSOR cur_per_details( p_person_id per_all_people_f.person_id%type,

2370: -- End Bug 5011003
2371: -- the following cursor can be used for dual purposes
2372: -- can pass the exact eff date or the eff_date-1 to pick the prior details
2373: --
2374: CURSOR cur_per_details( p_person_id per_all_people_f.person_id%type,
2375: p_eff_date ghr_pa_requests.effective_date%TYPE)
2376: IS
2377: SELECT last_name, middle_names, first_name,title,business_group_id
2378: FROM per_all_people_f

Line 2378: FROM per_all_people_f

2374: CURSOR cur_per_details( p_person_id per_all_people_f.person_id%type,
2375: p_eff_date ghr_pa_requests.effective_date%TYPE)
2376: IS
2377: SELECT last_name, middle_names, first_name,title,business_group_id
2378: FROM per_all_people_f
2379: WHERE person_id = p_person_id
2380: AND p_eff_date between effective_start_date and effective_end_date;
2381:
2382: -- Bug 5010844