DBA Data[Home] [Help]

APPS.IGS_CO_PROCESS dependencies on IGS_AD_PNMEMBR_DTLS

Line 891: igs_ad_pnmembr_dtls ipm

887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)
890: FROM igs_ad_panel_dtls ipl ,
891: igs_ad_pnmembr_dtls ipm
892: WHERE ipl.panel_dtls_id = ipm.panel_dtls_id AND
893: ipl.person_id = p_person_id AND
894: ipl.admission_appl_number =p_adm_appl_number AND
895: ipl.nominated_course_cd = p_nominated_course_cd AND