DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on HR_IN_UTILITY

Line 766: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)

762: AND g_end_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
763:
764: CURSOR csr_emp_name(p_person_id VARCHAR2)
765: IS
766: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
767: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
768: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
769: FROM per_people_f pep
770: WHERE pep.person_id = p_person_id

Line 767: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)

763:
764: CURSOR csr_emp_name(p_person_id VARCHAR2)
765: IS
766: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
767: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
768: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
769: FROM per_people_f pep
770: WHERE pep.person_id = p_person_id
771: AND g_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date ;

Line 768: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name

764: CURSOR csr_emp_name(p_person_id VARCHAR2)
765: IS
766: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
767: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
768: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
769: FROM per_people_f pep
770: WHERE pep.person_id = p_person_id
771: AND g_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date ;
772: