APPS.GHR_EHRI_DYNRPT dependencies on PER_ALL_PEOPLE

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

Line 2449: l_last_name per_all_people.last_name%type;

2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;
2450: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2451:
2452: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
2453: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;

Line 2466: l_business_group_id per_all_people.business_group_id%type;

2462: --
2463: -- Bug# 6158983
2464: l_value VARCHAR2(250);
2465: l_effective_start_date date;
2466: l_business_group_id per_all_people.business_group_id%type;
2467:
2468: -- Bug# 6158983
2469:
2470: BEGIN