APPS.IGS_AD_GEN_004 dependencies on IGS_PE_HZ_PARTIES

Line 165: FROM igs_pe_hz_parties pd

161: DECLARE
162: CURSOR c_pe(
163: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
164: SELECT pd.archive_dt
165: FROM igs_pe_hz_parties pd
166: WHERE pd.party_id = cp_person_id ;
167:
168: cst_yes CONSTANT CHAR := 'Y';
169: cst_no CONSTANT CHAR := 'N';