APPS.IGS_AD_VAL_AAL dependencies on IGS_AD_PRCS_CAT_STEP

Line 36: cp_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS

32: WHERE apcl.admission_cat = p_admission_cat AND
33: apcl.s_admission_process_type = p_s_admission_process_type AND
34: apcl.correspondence_type = p_correspondence_type;
35: CURSOR c_apcs (
36: cp_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
37: SELECT 'X'
38: FROM IGS_AD_PRCS_CAT_STEP apcs
39: WHERE apcs.admission_cat = p_admission_cat AND
40: apcs.s_admission_process_type = p_s_admission_process_type AND

Line 38: FROM IGS_AD_PRCS_CAT_STEP apcs

34: apcl.correspondence_type = p_correspondence_type;
35: CURSOR c_apcs (
36: cp_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
37: SELECT 'X'
38: FROM IGS_AD_PRCS_CAT_STEP apcs
39: WHERE apcs.admission_cat = p_admission_cat AND
40: apcs.s_admission_process_type = p_s_admission_process_type AND
41: apcs.s_admission_step_type = cp_step_type AND
42: apcs.step_group_type <> 'TRACK'; --2402377