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_SG_IRAS_ARCHIVE dependencies on FND_TERRITORIES_TL

Line 2862: fnd_territories_tl a

2858: addr.address_line3,
2859: lpad(nvl(addr.postal_code,'999999'),6,'0'),
2860: addr.country
2861: from per_addresses addr,
2862: fnd_territories_tl a
2863: where addr.person_id (+)= c_person_id
2864: and addr.primary_flag (+)= 'Y'
2865: and c_basis_end between nvl(addr.date_from, c_basis_start)
2866: and nvl(addr.date_to, c_basis_end) /* Bug 2654499 */

Line 2939: fnd_territories_tl a

2935: addr.address_line3,
2936: fnd_date.date_to_canonical(addr.date_from),
2937: fnd_date.date_to_canonical(nvl(addr.date_to,c_basis_end))/* if its not blank, return the real end date, bug 2654499 */
2938: from per_addresses addr,
2939: fnd_territories_tl a
2940: where addr.person_id (+) = c_person_id
2941: and a.territory_code (+)= addr.country
2942: and a.language (+)= userenv('LANG')
2943: and addr.address_type = 'SG_CQ' -- SG specific Company Quarters Address Type