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 359: l_emp_number per_people_f.employee_number%TYPE;

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

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

2303: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'
2304: -- selected by a user in the given period
2305: -- may as well select everyting from the PA Request table (saves going back!)
2306:
2307: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
2308: -- records based on business group id/security group id
2309: -- Not added outer join for per_people_f because we are expecting existence of person_id
2310: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
2311:

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

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

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,