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 2628: FROM hz_party_sites

2624: l_party_id IN NUMBER,
2625: l_party_site_id IN NUMBER)
2626: IS
2627: SELECT 'Y'
2628: FROM hz_party_sites
2629: WHERE party_id = l_party_id
2630: AND party_site_id = l_party_site_id;
2631:
2632: CURSOR c_validate_partner_contact(

Line 2729: FROM hz_party_sites

2725: CURSOR c_validate_party_address(
2726: l_party_site_id IN NUMBER )
2727: IS
2728: SELECT 'Y'
2729: FROM hz_party_sites
2730: WHERE party_site_id = l_party_site_id;
2731:
2732:
2733: CURSOR c_validate_party_contact(