APPS.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_PRCS_CAT_STEP

Line 450: CURSOR c_check_reconsider(cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

446: WHERE person_id = p_person_id
447: AND admission_appl_number = p_admission_appl_number
448: AND nominated_course_cd = p_nominated_program_cd;
449:
450: CURSOR c_check_reconsider(cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
451: SELECT 'X'
452: FROM IGS_AD_PRCS_CAT_STEP
453: WHERE admission_cat = cp_admission_cat
454: AND s_admission_process_type = cp_s_admission_process_type

Line 452: FROM IGS_AD_PRCS_CAT_STEP

448: AND nominated_course_cd = p_nominated_program_cd;
449:
450: CURSOR c_check_reconsider(cp_admission_cat IGS_AD_PRCS_CAT_STEP.ADMISSION_CAT%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
451: SELECT 'X'
452: FROM IGS_AD_PRCS_CAT_STEP
453: WHERE admission_cat = cp_admission_cat
454: AND s_admission_process_type = cp_s_admission_process_type
455: AND s_admission_step_type = 'RECONSIDER';
456:

Line 457: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

453: WHERE admission_cat = cp_admission_cat
454: AND s_admission_process_type = cp_s_admission_process_type
455: AND s_admission_step_type = 'RECONSIDER';
456:
457: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
458: SELECT 'Y'
459: FROM IGS_AD_PRCS_CAT_STEP
460: WHERE admission_cat = cp_admission_cat
461: AND s_admission_process_type = cp_s_admission_process_type

Line 459: FROM IGS_AD_PRCS_CAT_STEP

455: AND s_admission_step_type = 'RECONSIDER';
456:
457: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
458: SELECT 'Y'
459: FROM IGS_AD_PRCS_CAT_STEP
460: WHERE admission_cat = cp_admission_cat
461: AND s_admission_process_type = cp_s_admission_process_type
462: AND s_admission_step_type = 'PRE-ENROL'
463: AND step_group_type <> 'TRACK';

Line 1330: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,

1326: admission_appl_number = cp_admission_appl_number AND
1327: nominated_course_cd = cp_nominated_course_cd AND
1328: sequence_number = cp_sequence_number;
1329:
1330: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
1331: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
1332: SELECT s_admission_step_type,
1333: step_type_restriction_num
1334: FROM igs_ad_prcs_cat_step

Line 1331: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS

1327: nominated_course_cd = cp_nominated_course_cd AND
1328: sequence_number = cp_sequence_number;
1329:
1330: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
1331: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
1332: SELECT s_admission_step_type,
1333: step_type_restriction_num
1334: FROM igs_ad_prcs_cat_step
1335: WHERE admission_cat = cp_admission_cat AND

Line 1334: FROM igs_ad_prcs_cat_step

1330: CURSOR c_apcs (cp_admission_cat igs_ad_prcs_cat_step.admission_cat%TYPE,
1331: cp_s_admission_process_type igs_ad_prcs_cat_step.s_admission_process_type%TYPE) IS
1332: SELECT s_admission_step_type,
1333: step_type_restriction_num
1334: FROM igs_ad_prcs_cat_step
1335: WHERE admission_cat = cp_admission_cat AND
1336: s_admission_process_type = cp_s_admission_process_type AND
1337: step_group_type <> 'TRACK' ;
1338: