APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 830: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,

826:
827: c_admcat_rec c_admcat_cur%ROWTYPE;
828:
829: CURSOR c_apcs_cur (
830: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
831: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE
832: )
833: IS
834: SELECT

Line 831: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE

827: c_admcat_rec c_admcat_cur%ROWTYPE;
828:
829: CURSOR c_apcs_cur (
830: cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
831: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE
832: )
833: IS
834: SELECT
835: s_admission_step_type, step_type_restriction_num

Line 837: igs_ad_prcs_cat_step

833: IS
834: SELECT
835: s_admission_step_type, step_type_restriction_num
836: FROM
837: igs_ad_prcs_cat_step
838: WHERE
839: admission_cat = cp_admission_cat
840: AND s_admission_process_type = cp_s_admission_process_type
841: AND step_group_type <> 'TRACK';