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_PAYSLIP_ARCHIVE dependencies on HR_IN_UTILITY

Line 1451: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)

1447: ,pap.per_information8 pf_number
1448: ,pap.per_information9 esi_number
1449: ,pap.per_information4 pan
1450: ,pap.per_information10 superannuation_number
1451: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)
1452: FROM per_people_f pap
1453: WHERE pap.person_id = p_person_id
1454: AND p_date_earned BETWEEN pap.effective_start_date
1455: AND pap.effective_end_date;

Line 1832: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name

1828:
1829: -- Cursor to find Employee details
1830: CURSOR c_name_pfno_fh_name(p_assignment_action_id NUMBER)
1831: IS
1832: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
1833: ,pep.per_information8 PF_Number
1834: ,pep.per_information13 Pension_Number
1835: ,pep.person_id person_id
1836: ,con.contact_person_id contact

Line 1851: SELECT hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title) Father_Husbannd

1847: AND p_payroll_date between asg.effective_start_date and asg.effective_end_date;
1848:
1849: CURSOR csr_contact_details(p_contact_person_id NUMBER)
1850: IS
1851: SELECT hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title) Father_Husbannd
1852: FROM per_people_f pea
1853: WHERE pea.person_id = p_contact_person_id
1854: AND p_payroll_date between pea.effective_start_date and pea.effective_end_date;
1855:

Line 2471: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name

2467:
2468: -- Cursor to find full name, ESI number, Person Id
2469: CURSOR c_name_esino_fh_name(p_assignment_action_id NUMBER)
2470: IS
2471: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
2472: ,pep.per_information9 ESI_Number
2473: ,pep.person_id person_id
2474: FROM per_assignments_f asg
2475: ,per_people_f pep

Line 3123: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name

3119: --Cursor to find the PF/ESI Representative Name
3120: CURSOR c_rep_name(p_pf_org_id NUMBER
3121: ,p_effective_date DATE)
3122: IS
3123: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3124: ,peap.person_id person_id
3125: FROM hr_organization_information hoi
3126: ,per_people_f peap
3127: WHERE hoi.ORGANIZATION_ID=p_pf_org_id

Line 3445: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name

3441:
3442: -- Cursor to find full name, Person Id
3443: CURSOR c_person_full_name(p_assignment_action_id NUMBER)
3444: IS
3445: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3446: ,pep.person_id person_id
3447: FROM per_assignments_f asg
3448: ,per_people_f pep
3449: ,pay_assignment_actions paa

Line 3809: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name

3805: --Cursor to find the PF/ESI Representative Name
3806: CURSOR c_rep_name(p_pf_org_id NUMBER
3807: ,p_effective_date DATE)
3808: IS
3809: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3810: ,peap.person_id person_id
3811: FROM hr_organization_information hoi
3812: ,per_people_f peap
3813: WHERE hoi.organization_id = p_pf_org_id