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 2915: fnd_territories_tl a

2911: addr.postal_code,
2912: -- lpad(nvl(addr.postal_code,'999999'),6,'0'),
2913: addr.country
2914: from per_addresses addr,
2915: fnd_territories_tl a
2916: where addr.person_id (+)= c_person_id
2917: and addr.primary_flag (+)= 'Y'
2918: and c_basis_end between nvl(addr.date_from, c_basis_start)
2919: and nvl(addr.date_to, c_basis_end) /* Bug 2654499 */

Line 2995: fnd_territories_tl a

2991: addr.address_line3,
2992: fnd_date.date_to_canonical(addr.date_from),
2993: fnd_date.date_to_canonical(nvl(addr.date_to,c_basis_end))/* if its not blank, return the real end date, bug 2654499 */
2994: from per_addresses addr,
2995: fnd_territories_tl a
2996: where addr.person_id (+) = c_person_id
2997: and a.territory_code (+)= addr.country
2998: and a.language (+)= userenv('LANG')
2999: and addr.address_type = 'SG_CQ' -- SG specific Company Quarters Address Type