APPS.IGS_AD_GEN_004 dependencies on IGS_PE_PERSON

Line 163: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

159: BEGIN -- admp_get_archive_ind
160: -- Determine whether or not a person is archived
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: