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 735: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name

731:
732: CURSOR c_representative_id
733: IS
734: SELECT hoi.org_information1 person_id
735: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
736: ,pep.email_address email_id
737: FROM hr_organization_information hoi
738: ,hr_organization_units hou
739: ,per_people_f pep

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

985: IS
986: SELECT asg.person_id person_id
987: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
988: ,pep.per_information14 pan_ref_num
989: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
990: FROM per_assignments_f asg
991: ,per_people_f pep
992: WHERE asg.assignment_id = p_assignment_id
993: AND pep.person_id = asg.person_id

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

2293: IS
2294: SELECT asg.person_id person_id
2295: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2296: ,pep.per_information14 pan_ref_num
2297: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2298: FROM per_assignments_f asg
2299: ,per_people_f pep
2300: WHERE asg.assignment_id = p_assignment_id
2301: AND pep.person_id = asg.person_id