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.JTF_RS_RESOURCE_PUB dependencies on HZ_PARTY_SITES

Line 261: FROM hz_party_sites

257: l_party_id IN NUMBER,
258: l_party_site_id IN NUMBER)
259: IS
260: SELECT 'Y'
261: FROM hz_party_sites
262: WHERE party_id = l_party_id
263: AND party_site_id = l_party_site_id;
264:
265: CURSOR c_validate_partner_contact(

Line 365: FROM hz_party_sites

361: CURSOR c_validate_party_address(
362: l_party_site_id IN NUMBER )
363: IS
364: SELECT 'Y'
365: FROM hz_party_sites
366: WHERE party_site_id = l_party_site_id;
367:
368:
369: CURSOR c_validate_party_contact(

Line 2409: FROM hz_party_sites

2405: l_party_id IN NUMBER,
2406: l_party_site_id IN NUMBER)
2407: IS
2408: SELECT 'Y'
2409: FROM hz_party_sites
2410: WHERE party_id = l_party_id
2411: AND party_site_id = l_party_site_id;
2412:
2413: CURSOR c_validate_partner_contact(

Line 2510: FROM hz_party_sites

2506: CURSOR c_validate_party_address(
2507: l_party_site_id IN NUMBER )
2508: IS
2509: SELECT 'Y'
2510: FROM hz_party_sites
2511: WHERE party_site_id = l_party_site_id;
2512:
2513:
2514: CURSOR c_validate_party_contact(