APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 548: FROM igs_ad_prcs_cat_step apcs ,

544: AND closed_flag = 'N';
545:
546: CURSOR c_apcs_step_exist IS
547: SELECT 'X'
548: FROM igs_ad_prcs_cat_step apcs ,
549: igs_Ad_appl appl
550: WHERE appl.person_id = new_references.person_id
551: AND appl.admission_appl_number = new_references.admission_appl_number
552: AND apcs.admission_cat = appl.admission_cat