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.

[Home] [Help]

APPS.PAY_GB_RTI dependencies on PER_PEOPLE_EXTRA_INFO

Line 2068: per_people_extra_info ppei

2064: per_all_assignments_f asg,
2065: per_periods_of_service serv,
2066: pay_all_payrolls_f pay,
2067: hr_soft_coding_keyflex sck,
2068: per_people_extra_info ppei
2069: where pap.person_id between stperson and endperson
2070: and pap.person_id =ppei.person_id (+)
2071: /* and nvl(ppei.pei_information_category,'RTI_NINO') = 'RTI_NINO'
2072: and nvl(ppei.pei_information1,'No') = 'No'

Line 2076: and not exists( select 'Y' from per_people_extra_info ppei1

2072: and nvl(ppei.pei_information1,'No') = 'No'
2073: and ppei.pei_information5 is null
2074: */
2075: -- above 3 lines commented and added the below condition Bug -16536044
2076: and not exists( select 'Y' from per_people_extra_info ppei1
2077: where ppei1.person_id = pap.person_id
2078: and ppei1.pei_information_category = 'RTI_NINO'
2079: and nvl(ppei1.pei_information1,'Yes') <> 'No'
2080: and ( (ppei1.pei_information1 is null and ppei1.pei_information5 is not null)