APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_PEOPLE_F

Line 239: l_emp_num per_people_f.employee_number%type;

235: l_dummy VARCHAR2(1);
236: l_sid NUMBER;
237:
238: --Bug # 9329643
239: l_emp_num per_people_f.employee_number%type;
240: -- ****** MAIN Program CURSORS *********
241: -- Cursor to verify whether Person benefits EIT is created or not
242: CURSOR c_eit_exists IS
243: SELECT 'x'

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

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

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

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

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

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

Line 644: l_full_name per_people_f.full_name%type; --bug# 10419074

640: p_business_group_id in Number) is
641:
642: l_assignment_id pay_element_entries_f.assignment_id%type;
643: l_req VARCHAR2 (25);
644: l_full_name per_people_f.full_name%type; --bug# 10419074
645: l_log_text VARCHAR2(2000); --bug# 10419074
646: l_program_name ghr_process_log.program_name%TYPE;
647:
648: --Bug # 9329643

Line 649: l_emp_num per_people_f.employee_number%type;

645: l_log_text VARCHAR2(2000); --bug# 10419074
646: l_program_name ghr_process_log.program_name%TYPE;
647:
648: --Bug # 9329643
649: l_emp_num per_people_f.employee_number%type;
650:
651:
652: --Bug # 9329643 added employee number
653: Cursor cur_ssn is

Line 655: FROM per_assignments_f paf, per_people_f ppf

651:
652: --Bug # 9329643 added employee number
653: Cursor cur_ssn is
654: SELECT ppf.last_name,ppf.first_name, ppf.middle_names, ppf.employee_number --bug# 10419074
655: FROM per_assignments_f paf, per_people_f ppf
656: WHERE ppf.person_id = paf.person_id
657: AND paf.primary_flag = 'Y'
658: AND paf.assignment_type <> 'B'
659: AND to_date('2013/01/13','YYYY/MM/DD') BETWEEN paf.effective_start_date