APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_VER

Line 93: FROM IGS_PS_VER crv,

89: ca.acai_sequence_number = p_acai_sequence_number));
90: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;
91: CURSOR c_crv_cty IS
92: SELECT cty.research_type_ind
93: FROM IGS_PS_VER crv,
94: IGS_PS_TYPE cty
95: WHERE crv.course_cd = p_course_cd AND
96: crv.version_number = p_crv_version_number AND
97: crv.course_type = cty.course_type;

Line 685: FROM IGS_PS_VER crv,

681: v_cty_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
682: v_message_name varchar2(30);
683: CURSOR c_cty IS
684: SELECT cty.research_type_ind
685: FROM IGS_PS_VER crv,
686: IGS_PS_TYPE cty
687: WHERE crv.course_cd = p_course_cd AND
688: crv.version_number = p_crv_version_number AND
689: crv.course_type = cty.course_type;

Line 1816: cp_course_cd IGS_PS_VER.course_cd%TYPE,

1812: DECLARE
1813: v_rec_found BOOLEAN;
1814: v_other_detail VARCHAR2(255);
1815: CURSOR c_fund_source_rest(
1816: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1817: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1818: SELECT funding_source,
1819: restricted_ind
1820: FROM IGS_FI_FND_SRC_RSTN

Line 1817: cp_version_number IGS_PS_VER.version_number%TYPE) IS

1813: v_rec_found BOOLEAN;
1814: v_other_detail VARCHAR2(255);
1815: CURSOR c_fund_source_rest(
1816: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1817: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1818: SELECT funding_source,
1819: restricted_ind
1820: FROM IGS_FI_FND_SRC_RSTN
1821: WHERE course_cd = cp_course_cd AND

Line 1908: FROM IGS_PS_VER cv,

1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1905: l_dummy_boolean BOOLEAN;
1906: CURSOR c_cv IS
1907: SELECT 'x'
1908: FROM IGS_PS_VER cv,
1909: IGS_PS_STAT cs
1910: WHERE cv.course_cd = p_course_cd AND
1911: cv.version_number = p_version_number AND
1912: cs.course_status = cv.course_status AND

Line 2152: IGS_PS_VER crv

2148: CURSOR c_sct_sca_crv IS
2149: SELECT sca.commencement_dt
2150: FROM IGS_PS_STDNT_TRN sct,
2151: IGS_EN_STDNT_PS_ATT sca,
2152: IGS_PS_VER crv
2153: WHERE sct.person_id = p_person_id AND
2154: sca.person_id = sct.person_id AND
2155: sct.course_cd = p_course_cd AND
2156: sca.course_cd = sct.transfer_course_cd AND

Line 2835: from igs_ps_ver ps,

2831: Cursor cur_ps_ctype(cp_course_cd VARCHAR2,
2832: cp_version_number NUMBER,
2833: cp_person_id NUMBER) IS
2834: Select ps.course_type
2835: from igs_ps_ver ps,
2836: igs_en_stdnt_ps_att sca
2837: where ps.course_cd=cp_course_cd
2838: and ps.version_number = cp_version_number
2839: and sca.course_cd = ps.course_cd

Line 2848: igs_ps_ver pv

2844: Cursor cur_ps_sec(cp_person_id NUMBER,
2845: cp_course_type VARCHAR2) IS
2846: SELECT spa.course_cd
2847: FROM igs_en_stdnt_ps_att spa,
2848: igs_ps_ver pv
2849: WHERE spa.person_id = cp_person_id
2850: AND spa.primary_program_type = 'SECONDARY'
2851: AND spa.STUDENT_CONFIRMED_IND = 'Y'
2852: AND spa.course_cd = pv.course_cd

Line 2869: igs_ps_ver pv

2865: CURSOR cur_pri_prg(cp_person_id NUMBER,
2866: cp_course_type VARCHAR2) IS
2867: SELECT 'x'
2868: FROM igs_en_stdnt_ps_att spa,
2869: igs_ps_ver pv
2870: WHERE spa.person_id = cp_person_id
2871: AND spa.primary_program_type = 'PRIMARY'
2872: AND spa.course_cd = pv.course_cd
2873: AND spa.version_number = pv.version_number

Line 2887: l_career igs_ps_ver.course_type%TYPE;

2883:
2884:
2885: l_sua_check VARCHAR2(1);
2886: l_sua_unconfirm_check VARCHAR2(1);
2887: l_career igs_ps_ver.course_type%TYPE;
2888: l_sec_courseCD igs_en_stdnt_ps_att.course_cd%TYPE;
2889: l_primaryInd igs_en_stdnt_ps_att.primary_program_type%TYPE;
2890: l_pri_prg VARCHAR2(1);
2891: