APPS.IGS_RE_VAL_CA dependencies on IGS_AD_PRCS_CAT_STEP

Line 496: -- mandatory ie IGS_AD_PRCS_CAT_STEP.mandatory_step_ind 'Y' where for

492: -- acai_sequence_number) link cannot be removed if the admission application
493:
494: -- is defined by an admission process category where research details are
495:
496: -- mandatory ie IGS_AD_PRCS_CAT_STEP.mandatory_step_ind 'Y' where for
497:
498: -- IGS_AD_PRCS_CAT_STEP.s_admission_step_type 'RESEARCH' and
499:
500: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to

Line 498: -- IGS_AD_PRCS_CAT_STEP.s_admission_step_type 'RESEARCH' and

494: -- is defined by an admission process category where research details are
495:
496: -- mandatory ie IGS_AD_PRCS_CAT_STEP.mandatory_step_ind 'Y' where for
497:
498: -- IGS_AD_PRCS_CAT_STEP.s_admission_step_type 'RESEARCH' and
499:
500: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to
501:
502: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.

Line 516: -- details are collected ie IGS_AD_PRCS_CAT_STEP.s_admission_step_type

512: -- acai_nominated_course_cd/ acai_sequence_number) must map to an admission
513:
514: -- application defined by an admission process category where research
515:
516: -- details are collected ie IGS_AD_PRCS_CAT_STEP.s_admission_step_type
517:
518: -- 'RESEARCH' exists.
519:
520: DECLARE

Line 572: IGS_AD_PRCS_CAT_STEP apcs

568: SELECT 'x'
569:
570: FROM IGS_AD_APPL aa,
571:
572: IGS_AD_PRCS_CAT_STEP apcs
573:
574: WHERE aa.person_id = p_person_id AND
575:
576: aa.admission_appl_number = p_acai_admission_appl_number AND

Line 1337: v_mandatory_step_ind IGS_AD_PRCS_CAT_STEP.mandatory_step_ind%TYPE;

1333: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
1334:
1335: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
1336:
1337: v_mandatory_step_ind IGS_AD_PRCS_CAT_STEP.mandatory_step_ind%TYPE;
1338:
1339: CURSOR c_acai IS
1340:
1341: SELECT aos.s_adm_outcome_status,

Line 1375: IGS_AD_PRCS_CAT_STEP apcs

1371: SELECT apcs.mandatory_step_ind
1372:
1373: FROM IGS_AD_APPL aa,
1374:
1375: IGS_AD_PRCS_CAT_STEP apcs
1376:
1377: WHERE aa.person_id = p_person_id AND
1378:
1379: aa.admission_appl_number = p_acai_admission_appl_number AND