APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_EN_STDNT_PS_ATT

Line 47: FROM IGS_EN_STDNT_PS_ATT sca,

43: gr.s_graduand_type,
44: gr.conferral_dt,
45: gst.s_graduand_status,
46: aw.award_title
47: FROM IGS_EN_STDNT_PS_ATT sca,
48: IGS_GR_GRADUAND gr,
49: IGS_GR_STAT gst,
50: IGS_CA_INST ci,
51: IGS_PS_AWD aw

Line 83: FROM IGS_EN_STDNT_PS_ATT sca,

79: NULL,
80: SYSDATE,
81: NULL,
82: NULL
83: FROM IGS_EN_STDNT_PS_ATT sca,
84: IGS_CA_INST ci
85: WHERE sca.person_id = p_person_id AND
86: sca.course_cd = p_course_cd AND
87: sca.course_rqrmnt_complete_ind = 'Y' AND

Line 285: IGS_EN_STDNT_PS_ATT sca,

281: th.final_title_ind,
282: ci.alternate_code
283: FROM IGS_RE_CANDIDATURE ca,
284: IGS_RE_THESIS th,
285: IGS_EN_STDNT_PS_ATT sca,
286: IGS_CA_INST ci
287: WHERE ca.person_id = p_person_id AND
288: ca.sca_course_cd = p_course_cd AND
289: ca.person_id = th.person_id AND

Line 1012: FROM IGS_EN_STDNT_PS_ATT sca,

1008: NULL n4,
1009: SYSDATE,
1010: NULL n5,
1011: NULL n6
1012: FROM IGS_EN_STDNT_PS_ATT sca,
1013: IGS_CA_INST ci
1014: WHERE sca.person_id = p_person_id AND
1015: sca.course_cd = p_course_cd AND
1016: sca.lapsed_dt IS NOT NULL AND

Line 1040: FROM IGS_EN_STDNT_PS_ATT sca,

1036: NULL n7,
1037: SYSDATE,
1038: NULL n8,
1039: NULL n9
1040: FROM IGS_EN_STDNT_PS_ATT sca,
1041: IGS_CA_INST ci
1042: WHERE sca.person_id = p_person_id AND
1043: sca.course_cd = p_course_cd AND
1044: sca.discontinued_dt IS NOT NULL AND

Line 1235: igs_en_stdnt_ps_att sca

1231: suav.unit_attempt_status, suav.administrative_unit_status
1232: FROM igs_en_su_attempt_all suav,
1233: igs_ps_usec_cps cps,
1234: igs_ps_unit_ver uv,
1235: igs_en_stdnt_ps_att sca
1236: WHERE suav.person_id = p_person_id
1237: AND suav.course_cd = p_course_cd
1238: AND sca.person_id = suav.person_id
1239: AND sca.course_cd = suav.course_cd

Line 1283: FROM IGS_EN_STDNT_PS_ATT sca,

1279: DECLARE
1280: v_dummy VARCHAR2(1);
1281: CURSOR c_cv IS
1282: SELECT 'x'
1283: FROM IGS_EN_STDNT_PS_ATT sca,
1284: IGS_PS_VER cv
1285: WHERE sca.person_id = p_person_id AND
1286: sca.course_cd = p_course_cd AND
1287: cv.course_cd = sca.course_cd AND

Line 2014: FROM IGS_EN_STDNT_PS_ATT sca,

2010: sca.commencement_dt,
2011: cv.generic_course_ind,
2012: -- anilk, 22-Apr-2003, Bug# 2829262
2013: suav.uoo_id
2014: FROM IGS_EN_STDNT_PS_ATT sca,
2015: IGS_EN_SUA_V suav,
2016: IGS_PS_VER cv,
2017: IGS_PS_OFR_PAT cop,
2018: IGS_CA_INST ci

Line 2108: FROM IGS_EN_STDNT_PS_ATT sca,

2104: sca.commencement_dt,
2105: cv.generic_course_ind,
2106: -- anilk, 22-Apr-2003, Bug# 2829262
2107: suav.uoo_id
2108: FROM IGS_EN_STDNT_PS_ATT sca,
2109: IGS_EN_SUA_V suav,
2110: IGS_PS_VER cv,
2111: IGS_PS_OFR_PAT cop,
2112: IGS_CA_INST ci