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_PAYSGI21_XMLP_PKG dependencies on DUAL

Line 289: (select (lp_basis_year) yr from dual union

285: ppeo.pei_information3 no_days,
286: ppeo.pei_information4 no_employees,
287: yrtbl.yr yr
288: from per_people_extra_info ppeo,
289: (select (lp_basis_year) yr from dual union
290: select (lp_basis_year - 1) yr from dual union
291: select (lp_basis_year - 2) yr from dual) yrtbl
292: where ppeo.person_id = person_id
293: and ppeo.information_type = 'HR_IR21A_CESSATION_INFO_SG'

Line 290: select (lp_basis_year - 1) yr from dual union

286: ppeo.pei_information4 no_employees,
287: yrtbl.yr yr
288: from per_people_extra_info ppeo,
289: (select (lp_basis_year) yr from dual union
290: select (lp_basis_year - 1) yr from dual union
291: select (lp_basis_year - 2) yr from dual) yrtbl
292: where ppeo.person_id = person_id
293: and ppeo.information_type = 'HR_IR21A_CESSATION_INFO_SG'
294: and fnd_date.canonical_to_date(ppeo.pei_information1) =

Line 291: select (lp_basis_year - 2) yr from dual) yrtbl

287: yrtbl.yr yr
288: from per_people_extra_info ppeo,
289: (select (lp_basis_year) yr from dual union
290: select (lp_basis_year - 1) yr from dual union
291: select (lp_basis_year - 2) yr from dual) yrtbl
292: where ppeo.person_id = person_id
293: and ppeo.information_type = 'HR_IR21A_CESSATION_INFO_SG'
294: and fnd_date.canonical_to_date(ppeo.pei_information1) =
295: (select max(fnd_date.canonical_to_date(ppeo2.pei_information1))