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 1579: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)

1575: ,pap.per_information8 pf_number
1576: ,pap.per_information9 esi_number
1577: ,pap.per_information4 pan
1578: ,pap.per_information10 superannuation_number
1579: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)
1580: ,pap.email_address
1581: FROM per_people_f pap
1582: WHERE pap.person_id = p_person_id
1583: AND p_date_earned BETWEEN pap.effective_start_date

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

1974:
1975: -- Cursor to find Employee details
1976: CURSOR c_name_pfno_fh_name(p_assignment_action_id NUMBER)
1977: IS
1978: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
1979: ,pep.per_information8 PF_Number
1980: ,pep.per_information13 Pension_Number
1981: ,pep.person_id person_id
1982: ,con.contact_person_id contact

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

1996: AND p_payroll_date between asg.effective_start_date and asg.effective_end_date;
1997:
1998: CURSOR csr_contact_details(p_contact_person_id NUMBER)
1999: IS
2000: SELECT hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title) Father_Husbannd
2001: FROM per_people_f pea
2002: WHERE pea.person_id = p_contact_person_id
2003: AND p_payroll_date between pea.effective_start_date and pea.effective_end_date;
2004:

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

2679:
2680: -- Cursor to find full name, ESI number, Person Id
2681: CURSOR c_name_esino_fh_name(p_assignment_action_id NUMBER)
2682: IS
2683: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
2684: ,pep.per_information9 ESI_Number
2685: ,pep.person_id person_id
2686: FROM per_assignments_f asg
2687: ,per_people_f pep

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

3331: --Cursor to find the PF/ESI Representative Name
3332: CURSOR c_rep_name(p_pf_org_id NUMBER
3333: ,p_effective_date DATE)
3334: IS
3335: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3336: ,peap.person_id person_id
3337: FROM hr_organization_information hoi
3338: ,per_people_f peap
3339: WHERE hoi.ORGANIZATION_ID=p_pf_org_id

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

3661:
3662: -- Cursor to find full name, Person Id
3663: CURSOR c_person_full_name(p_assignment_action_id NUMBER)
3664: IS
3665: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3666: ,pep.person_id person_id
3667: FROM per_assignments_f asg
3668: ,per_people_f pep
3669: ,pay_assignment_actions paa

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

4025: --Cursor to find the PF/ESI Representative Name
4026: CURSOR c_rep_name(p_pf_org_id NUMBER
4027: ,p_effective_date DATE)
4028: IS
4029: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
4030: ,peap.person_id person_id
4031: FROM hr_organization_information hoi
4032: ,per_people_f peap
4033: WHERE hoi.organization_id = p_pf_org_id