APPS.GHR_CPDF_DYNRPT dependencies on PER_PEOPLE_F

Line 327: l_emp_number per_people_f.employee_number%TYPE;

323: ,p_rating_of_record_pattern OUT NOCOPY VARCHAR2
324: ,p_rating_of_record_period OUT NOCOPY DATE) IS
325: --
326: l_special_info ghr_api.special_information_type;
327: l_emp_number per_people_f.employee_number%TYPE;
328: CURSOR c_per IS
329: SELECT per.employee_number
330: FROM per_people_f per
331: WHERE per.person_id = p_person_id

Line 330: FROM per_people_f per

326: l_special_info ghr_api.special_information_type;
327: l_emp_number per_people_f.employee_number%TYPE;
328: CURSOR c_per IS
329: SELECT per.employee_number
330: FROM per_people_f per
331: WHERE per.person_id = p_person_id
332: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
333: AND per.effective_end_date;
334: BEGIN

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

1134: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'
1135: -- selected by a user in the given period
1136: -- may as well select everyting from the PA Request table (saves going back!)
1137:
1138: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
1139: -- records based on business group id/security group id
1140: -- Not added outer join for per_people_f because we are expecting existence of person_id
1141: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
1142:

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

1136: -- may as well select everyting from the PA Request table (saves going back!)
1137:
1138: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
1139: -- records based on business group id/security group id
1140: -- Not added outer join for per_people_f because we are expecting existence of person_id
1141: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
1142:
1143: -- 24-OCT-2002 JH truncated sf50_approval_date because it does contain time on the db.
1144: -- which causes some rows to not be included on last day.

Line 1149: per_people_f per

1145:
1146: CURSOR cur_get_pars IS
1147: SELECT par.*
1148: FROM ghr_pa_requests par,
1149: per_people_f per
1150: WHERE NVL(par.agency_code,par.from_agency_code) LIKE p_agency
1151: AND par.person_id = per.person_id
1152: AND trunc(par.sf50_approval_date) BETWEEN per.effective_start_date
1153: AND per.effective_end_date