APPS.IGF_SL_LAR_CREATION dependencies on IGS_PR_CS_SCHDL

Line 951: SELECT CSSV.igs_pr_cs_schdl_id ,

947:
948: -- Cursor to get cs_schdl_id, class_std_id, css_class_std_id
949: CURSOR c_class_std ( cp_class_standing igs_pr_css_class_std_v.class_standing%TYPE ,
950: cp_program_type igs_ps_ver_all.course_type%TYPE ) IS
951: SELECT CSSV.igs_pr_cs_schdl_id ,
952: CSSV.igs_pr_class_std_id ,
953: CSSV.igs_pr_css_class_std_id
954: FROM igs_pr_css_class_std_v CSSV
955: WHERE CSSV.igs_pr_cs_schdl_id = (SELECT igs_pr_cs_schdl_id

Line 955: WHERE CSSV.igs_pr_cs_schdl_id = (SELECT igs_pr_cs_schdl_id

951: SELECT CSSV.igs_pr_cs_schdl_id ,
952: CSSV.igs_pr_class_std_id ,
953: CSSV.igs_pr_css_class_std_id
954: FROM igs_pr_css_class_std_v CSSV
955: WHERE CSSV.igs_pr_cs_schdl_id = (SELECT igs_pr_cs_schdl_id
956: FROM igs_pr_cs_schdl CS
957: WHERE CS.course_type = cp_program_type )
958: AND CSSV.class_standing = cp_class_standing ;
959: lv_class_std_rec c_class_std%ROWTYPE ;

Line 956: FROM igs_pr_cs_schdl CS

952: CSSV.igs_pr_class_std_id ,
953: CSSV.igs_pr_css_class_std_id
954: FROM igs_pr_css_class_std_v CSSV
955: WHERE CSSV.igs_pr_cs_schdl_id = (SELECT igs_pr_cs_schdl_id
956: FROM igs_pr_cs_schdl CS
957: WHERE CS.course_type = cp_program_type )
958: AND CSSV.class_standing = cp_class_standing ;
959: lv_class_std_rec c_class_std%ROWTYPE ;
960:

Line 964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,

960:
961: -- Cursor to get dl_std_code
962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,

Line 971: AND PPT.igs_pr_cs_schdl_id = cp_cs_schdl_id

967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,
969: igf_ap_pr_prg_type PPT
970: WHERE PPT.ppt_id = CSM.ppt_id
971: AND PPT.igs_pr_cs_schdl_id = cp_cs_schdl_id
972: AND PPT.cal_type = cp_ci_cal_type
973: AND PPT.sequence_number = cp_ci_sequence_number
974: AND CSM.igs_pr_css_class_std_id = cp_css_class_std_id ;
975: lv_dl_cl_std_code_rec c_dl_cl_std_code%ROWTYPE ;

Line 1003: lv_class_std_rec.igs_pr_cs_schdl_id,

999:
1000: -- GET direct loan std code using ci_cal_type, ci_sequence_number, schdl_id and class_standing_id
1001: OPEN c_dl_cl_std_code ( lv_person_info_rec.ci_cal_type,
1002: lv_person_info_rec.ci_sequence_number,
1003: lv_class_std_rec.igs_pr_cs_schdl_id,
1004: lv_class_std_rec.igs_pr_css_class_std_id ) ;
1005: FETCH c_dl_cl_std_code INTO lv_dl_cl_std_code_rec ;
1006: IF c_dl_cl_std_code%NOTFOUND THEN
1007: CLOSE c_dl_cl_std_code ;