APPS.IGS_EN_GEN_012 dependencies on IGS_EN_SPI_RCONDS

Line 2528: FROM igs_en_spi_rconds rc, hz_parties hz

2524: cp_course_cd igs_ps_ver.course_cd%TYPE,
2525: cp_start_dt DATE,
2526: cp_logical_del_dt DATE) IS
2527: SELECT hz.party_number
2528: FROM igs_en_spi_rconds rc, hz_parties hz
2529: WHERE rc.person_id = hz.party_id
2530: AND rc.person_id =cp_person_id
2531: AND rc.course_cd =cp_course_cd
2532: AND rc.start_dt =cp_start_dt