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_MX_YREND_ARCH dependencies on FND_NUMBER

Line 1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,

1393: -- Get Other ER info for ERs of the current year
1394: CURSOR c_get_other_er_info(cp_person_id NUMBER,
1395: cp_effective_date DATE) IS
1396: SELECT pei_information1 RFC,
1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings

Line 1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,

1394: CURSOR c_get_other_er_info(cp_person_id NUMBER,
1395: cp_effective_date DATE) IS
1396: SELECT pei_information1 RFC,
1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1402: FROM per_people_extra_info

Line 1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,

1395: cp_effective_date DATE) IS
1396: SELECT pei_information1 RFC,
1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1402: FROM per_people_extra_info
1403: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'

Line 1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,

1396: SELECT pei_information1 RFC,
1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1402: FROM per_people_extra_info
1403: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1404: AND person_id = cp_person_id

Line 1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings

1397: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1398: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1399: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1400: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1402: FROM per_people_extra_info
1403: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1404: AND person_id = cp_person_id
1405: AND TO_CHAR(fnd_date.canonical_to_date(pei_information4), 'YYYY') =