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_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_ADDR_V

Line 1869: FROM igs_pe_addr_v adr,

1865: state,
1866: province,
1867: country_cd,
1868: postal_code
1869: FROM igs_pe_addr_v adr,
1870: igs_pe_partysiteuse_v usg
1871: WHERE person_id = p_person_rec.person_id
1872: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
1873: AND usg.party_site_id = adr.party_site_id

Line 2044: FROM igs_pe_addr_v adr,

2040: province,
2041: country_cd,
2042: postal_code,
2043: adr.identifying_address_flag
2044: FROM igs_pe_addr_v adr,
2045: igs_pe_partysiteuse_v usg
2046: WHERE person_id = p_person_rec.person_id
2047: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
2048: AND usg.party_site_id = adr.party_site_id

Line 2192: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE

2188:
2189: Change History
2190: Who When What
2191: pkpatel 23-APR-2003 Bug No 2908378
2192: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE
2193: Selected LOCATION_ID instead of PARTY_SITE_ID for these cases.
2194: Added p_data_rec(l_counter).party_site_id := c_addr_rec.party_site_id
2195: gmaheswa 12-Nov-2003 Modified c_addr cursor to select active address records,
2196: as part of address related changes .