APPS.IGS_AD_GEN_010 dependencies on HZ_PARTIES

Line 252: FROM hz_parties

248: api.api_person_id = p_tac_person_id;
249: CURSOR c_tac_id_pe(
250: cp_given_names VARCHAR2) IS
251: SELECT party_id person_id
252: FROM hz_parties
253: WHERE person_last_name = p_surname AND
254: person_first_name = cp_given_names;
255: CURSOR c_course_offer IS
256: SELECT ceprc.course_cd,