APPS.PAY_IN_PF_ARCHIVE dependencies on HR_IN_UTILITY

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

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

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

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

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

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