DBA Data[Home] [Help]

APPS.IGS_RE_VAL_CA dependencies on IGS_PS_VER

Line 480: -- a research IGS_PS_COURSE (defined by IGS_PS_VER.course_cd/ version_number

476: -- acai_sequence_number) link cannot be removed if the new application is
477:
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

Line 1349: IGS_PS_VER crv,

1345: FROM IGS_AD_PS_APPL_INST acai,
1346:
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

Line 1528: IGS_PS_VER crv,

1524: cty.research_type_ind
1525:
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