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_AS_GEN_006 dependencies on IGS_PE_PERSON_ADDR

Line 1274: -- Retrieve the record only if the person has a valid person address (exists in table and igs_pe_person_addr)

1270: igs_pe_person
1271: WHERE
1272: person_id = cp_person_id;
1273:
1274: -- Retrieve the record only if the person has a valid person address (exists in table and igs_pe_person_addr)
1275: -- and current date (sysdate) is :-
1276: -- Greater than start date and end date is null
1277: -- OR
1278: -- Between the start date and end date

Line 1290: igs_pe_person_addr pa

1286: pa.addr_line_4,
1287: pa.postal_code,
1288: pa.correspondence_ind
1289: FROM
1290: igs_pe_person_addr pa
1291: WHERE
1292: pa.person_id = cp_person_id
1293: AND
1294: ( pa.status = 'A'