eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_VAL_CA dependencies on IGS_PS_TYPE

Line 482: -- mapping to IGS_PS_TYPE.research_type_ind set to 'Y') and

478: -- not re-admission and the IGS_PS_COURSE version of the admission application is
479:
480: -- a research IGS_PS_COURSE (defined by IGS_PS_VER.course_cd/ version_number
481:
482: -- mapping to IGS_PS_TYPE.research_type_ind set to 'Y') and
483:
484: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to
485:
486: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.

Line 1335: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;

1331: DECLARE
1332:
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

Line 1351: IGS_PS_TYPE cty

1347: IGS_AD_OU_STAT aos,
1348:
1349: IGS_PS_VER crv,
1350:
1351: IGS_PS_TYPE cty
1352:
1353: WHERE acai.person_id = p_person_id AND
1354:
1355: acai.admission_appl_number = p_acai_admission_appl_number AND

Line 1518: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;

1514: DECLARE
1515:
1516: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1517:
1518: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
1519:
1520: CURSOR c_sca IS
1521:
1522: SELECT sca.student_confirmed_ind,

Line 1530: IGS_PS_TYPE cty

1526: FROM IGS_EN_STDNT_PS_ATT sca,
1527:
1528: IGS_PS_VER crv,
1529:
1530: IGS_PS_TYPE cty
1531:
1532: WHERE sca.course_cd = crv.course_cd AND
1533:
1534: sca.version_number = crv.version_number AND