APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_PEOPLE_F

Line 302: PROCEDURE get_person_name_ssn(p_person_id IN per_people_f.person_id%TYPE

298: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);
299: END print_ben_record;
300:
301: -- Procedure to get person Full Name, SSN
302: PROCEDURE get_person_name_ssn(p_person_id IN per_people_f.person_id%TYPE
303: ,p_effective_date IN DATE
304: ,p_full_name OUT NOCOPY per_people_f.full_name%TYPE
305: ,p_national_identifier OUT NOCOPY per_people_f.national_identifier%TYPE
306: ) IS

Line 304: ,p_full_name OUT NOCOPY per_people_f.full_name%TYPE

300:
301: -- Procedure to get person Full Name, SSN
302: PROCEDURE get_person_name_ssn(p_person_id IN per_people_f.person_id%TYPE
303: ,p_effective_date IN DATE
304: ,p_full_name OUT NOCOPY per_people_f.full_name%TYPE
305: ,p_national_identifier OUT NOCOPY per_people_f.national_identifier%TYPE
306: ) IS
307: CURSOR cur_per IS
308: SELECT per.full_name

Line 305: ,p_national_identifier OUT NOCOPY per_people_f.national_identifier%TYPE

301: -- Procedure to get person Full Name, SSN
302: PROCEDURE get_person_name_ssn(p_person_id IN per_people_f.person_id%TYPE
303: ,p_effective_date IN DATE
304: ,p_full_name OUT NOCOPY per_people_f.full_name%TYPE
305: ,p_national_identifier OUT NOCOPY per_people_f.national_identifier%TYPE
306: ) IS
307: CURSOR cur_per IS
308: SELECT per.full_name
309: ,per.national_identifier

Line 640: FROM per_assignments_f paf, per_people_f ppf

636: where assignment_id = l_assignment_id;
637:
638: Cursor cur_ssn is
639: SELECT ppf.national_identifier
640: FROM per_assignments_f paf, per_people_f ppf
641: WHERE ppf.person_id = paf.person_id
642: AND paf.primary_flag = 'Y'
643: AND paf.assignment_type <> 'B'
644: AND to_date('2009/01/04','YYYY/MM/DD') BETWEEN paf.effective_start_date