APPS.GHR_EHRI_DYNRPT dependencies on PER_ALL_PEOPLE

Line 204: FROM per_all_people_f per

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

Line 364: FROM per_all_people_f per -- Bug 4349372

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

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

2429:
2430: -- 24-OCT-2002 JH truncated sf50_approval_date because it does contain time on the db.
2431: -- which causes some rows to not be included on last day.
2432:
2433: -- Bug 4349372 changed per_people_f to per_all_people_f.
2434:
2435: --8486208
2436: l_agencies_with_se VARCHAR2(240);
2437: l_agencies_without_se VARCHAR2(240);

Line 2443: per_all_people_f per

2439: CURSOR cur_get_pars(p_agencies_with_se in varchar2,
2440: p_agencies_without_se in varchar2) IS
2441: SELECT par.*
2442: FROM ghr_pa_requests par,
2443: per_all_people_f per
2444: --8486208 added for new parameter
2445: WHERE ((p_agency is not null and NVL(par.agency_code,par.from_agency_code) LIKE p_agency)
2446: OR
2447: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,NVL(par.agency_code,par.from_agency_code),1) > 0)

Line 2467: per_all_people_f per

2463: --Bug # 10158391 added the union condition to consider the records approved in last month and effective in the reporting period
2464: UNION
2465: SELECT par.*
2466: FROM ghr_pa_requests par,
2467: per_all_people_f per
2468: --8486208 added for new parameter
2469: WHERE ((p_agency is not null and NVL(par.agency_code,par.from_agency_code) LIKE p_agency)
2470: OR
2471: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,NVL(par.agency_code,par.from_agency_code),1) > 0)

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

2524: -- End Bug 5011003
2525: -- the following cursor can be used for dual purposes
2526: -- can pass the exact eff date or the eff_date-1 to pick the prior details
2527: --
2528: CURSOR cur_per_details( p_person_id per_all_people_f.person_id%type,
2529: p_eff_date ghr_pa_requests.effective_date%TYPE)
2530: IS
2531: SELECT last_name, middle_names, first_name,title,business_group_id
2532: FROM per_all_people_f

Line 2532: FROM per_all_people_f

2528: CURSOR cur_per_details( p_person_id per_all_people_f.person_id%type,
2529: p_eff_date ghr_pa_requests.effective_date%TYPE)
2530: IS
2531: SELECT last_name, middle_names, first_name,title,business_group_id
2532: FROM per_all_people_f
2533: WHERE person_id = p_person_id
2534: AND p_eff_date between effective_start_date and effective_end_date;
2535:
2536: -- Bug 5010844

Line 2603: l_last_name per_all_people.last_name%type;

2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2602: ll_per_ei_data per_people_extra_info%rowtype;
2603: l_last_name per_all_people.last_name%type;
2604: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2605:
2606: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
2607: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;

Line 2620: l_business_group_id per_all_people.business_group_id%type;

2616: --
2617: -- Bug# 6158983
2618: l_value VARCHAR2(250);
2619: l_effective_start_date date;
2620: l_business_group_id per_all_people.business_group_id%type;
2621:
2622: --Bug # 9329643
2623: l_employee_number per_people_f.employee_number%TYPE;
2624: