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.IGS_SV_BATCH_PROCESS_PKG dependencies on HZ_PARTY_SITE_USES

Line 1048: hz_party_site_uses usg

1044: SELECT 1
1045: FROM hz_locations loc,
1046: hz_party_sites ps,
1047: igs_pe_hz_pty_sites igsps,
1048: hz_party_site_uses usg
1049: WHERE
1050: ps.location_id = loc.location_id
1051: AND ps.party_site_id = igsps.party_site_id (+)
1052: AND ps.party_site_id = cp_party_site_id

Line 2472: hz_party_site_uses usg

2468: null remarks
2469: FROM HZ_LOCATIONS loc,
2470: HZ_PARTY_SITES ps,
2471: IGS_PE_HZ_PTY_SITES IGSPS,
2472: hz_party_site_uses usg
2473: WHERE
2474: PS.LOCATION_ID = Loc.LOCATION_ID
2475: AND PS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID (+)
2476: and ps.party_id = p_person_rec.person_id

Line 2524: hz_party_site_uses usg

2520: null remarks
2521: from HZ_LOCATIONS loc,
2522: HZ_PARTY_SITES ps,
2523: IGS_PE_HZ_PTY_SITES IGSPS,
2524: hz_party_site_uses usg
2525: where
2526: PS.LOCATION_ID = Loc.LOCATION_ID
2527: AND PS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID (+)
2528: and ps.party_id = p_person_rec.person_id

Line 2591: hz_party_site_uses usg

2587: (a.end_date IS NULL OR sysdate between a.start_date and a.end_date)*/
2588: UNION
2589: SELECT adr.party_site_id
2590: FROM igs_pe_addr_v adr,
2591: hz_party_site_uses usg
2592: WHERE person_id = p_person_rec.person_id
2593: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(adr.start_dt,SYSDATE) AND NVL(adr.end_dt, SYSDATE + 1))
2594: AND usg.party_site_id = adr.party_site_id
2595: AND usg.site_use_type = 'SEVIS_SITE_OF_ACTIVITY'