DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PER_PEOPLE_EXTRA_INFO

Line 1402: FROM per_people_extra_info

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') =
1406: TO_CHAR(cp_effective_date, 'YYYY')