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 1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,

1635: -- Get Other ER info for ERs of the current year
1636: CURSOR c_get_other_er_info(cp_person_id NUMBER,
1637: cp_effective_date DATE) IS
1638: SELECT pei_information1 RFC,
1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings

Line 1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,

1636: CURSOR c_get_other_er_info(cp_person_id NUMBER,
1637: cp_effective_date DATE) IS
1638: SELECT pei_information1 RFC,
1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1644: FROM per_people_extra_info

Line 1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,

1637: cp_effective_date DATE) IS
1638: SELECT pei_information1 RFC,
1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1644: FROM per_people_extra_info
1645: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'

Line 1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,

1638: SELECT pei_information1 RFC,
1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1644: FROM per_people_extra_info
1645: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1646: AND person_id = cp_person_id

Line 1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings

1639: fnd_number.canonical_to_number(pei_information5) ISR_Withheld,
1640: fnd_number.canonical_to_number(pei_information6) Cr_Subsidy,
1641: fnd_number.canonical_to_number(pei_information7) Non_Cr_Subsidy,
1642: fnd_number.canonical_to_number(pei_information8) Total_Earnings,
1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1644: FROM per_people_extra_info
1645: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1646: AND person_id = cp_person_id
1647: AND TO_CHAR(fnd_date.canonical_to_date(pei_information4), 'YYYY') =

Line 1943: SELECT nvl(fnd_number.canonical_to_number(value),0)

1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')
1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');
1941: /* Bug 13093752 */
1942: CURSOR c_get_amends_amount IS
1943: SELECT nvl(fnd_number.canonical_to_number(value),0)
1944: FROM ff_archive_items
1945: WHERE user_entity_id = (SELECT user_entity_id
1946: FROM ff_user_entities
1947: WHERE user_entity_name = 'A_AMENDS_PER_PDS_GRE_YTD')