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'