eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_EHRI_DYNRPT dependencies on PER_PEOPLE_F

Line 361: l_emp_number per_people_f.employee_number%TYPE;

357: ,p_rating_of_rec_period_starts OUT NOCOPY DATE)
358: IS
359: --
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

Line 2425: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the

2421: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'
2422: -- selected by a user in the given period
2423: -- may as well select everyting from the PA Request table (saves going back!)
2424:
2425: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
2426: -- records based on business group id/security group id
2427: -- Not added outer join for per_people_f because we are expecting existence of person_id
2428: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
2429:

Line 2427: -- Not added outer join for per_people_f because we are expecting existence of person_id

2423: -- may as well select everyting from the PA Request table (saves going back!)
2424:
2425: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
2426: -- records based on business group id/security group id
2427: -- Not added outer join for per_people_f because we are expecting existence of person_id
2428: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
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.

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 2623: l_employee_number per_people_f.employee_number%TYPE;

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:
2625: -- Bug# 6158983
2626:
2627: --6850492