eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24Q_ARCHIVE dependencies on HR_IN_UTILITY

Line 708: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name

704:
705: CURSOR c_representative_id
706: IS
707: SELECT hoi.org_information1 person_id
708: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
709: ,pep.email_address email_id
710: FROM hr_organization_information hoi
711: ,hr_organization_units hou
712: ,per_people_f pep

Line 908: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name

904: IS
905: SELECT asg.person_id person_id
906: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
907: ,pep.per_information14 pan_ref_num
908: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
909: FROM per_assignments_f asg
910: ,per_people_f pep
911: WHERE asg.assignment_id = p_assignment_id
912: AND pep.person_id = asg.person_id

Line 2191: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name

2187: IS
2188: SELECT asg.person_id person_id
2189: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2190: ,pep.per_information14 pan_ref_num
2191: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2192: FROM per_assignments_f asg
2193: ,per_people_f pep
2194: WHERE asg.assignment_id = p_assignment_id
2195: AND pep.person_id = asg.person_id