APPS.IGF_SL_LAR_CREATION dependencies on IGS_PR_CSS_CLASS_STD_V

Line 88: -- igs_pr_css_class_std_v.class_standing%TYPE and

84: is now done from the FFELP loan Setup.
85: Added the common framework logging messages.
86:
87: -- rasahoo 02-Sep-2003 Replaced igf_ap_fa_base_h.class_standing%TYPE with
88: -- igs_pr_css_class_std_v.class_standing%TYPE and
89: -- igf_ap_fa_base_h.enrl_program_type%TYPE with igs_ps_ver_all.course_type%TYPE.
90: -- gmuralid 3-Juyl-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
91: -- Added legacy record flag as parameter to
92: -- igf_sl_loans_pkg

Line 925: p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,

921:
922: END ret_loan_number;
923:
924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
925: p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,
926: p_program_type IN igs_ps_ver_all.course_type%TYPE ,
927: p_dl_std_code OUT NOCOPY igf_ap_class_std_map.dl_std_code%TYPE ,
928: p_cl_std_code OUT NOCOPY igf_ap_class_std_map.cl_std_code%TYPE )
929: AS

Line 949: CURSOR c_class_std ( cp_class_standing igs_pr_css_class_std_v.class_standing%TYPE ,

945: WHERE base_id = cp_base_id ;
946: lv_person_info_rec c_person_info%ROWTYPE ;
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

Line 954: FROM igs_pr_css_class_std_v CSSV

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
956: FROM igs_pr_cs_schdl CS
957: WHERE CS.course_type = cp_program_type )
958: AND CSSV.class_standing = cp_class_standing ;

Line 1094: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;

1090: l_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1091:
1092:
1093: -- Declarations as part of bug 2385334
1094: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;
1095: lv_program_type igs_ps_ver_all.course_type%TYPE;
1096: -- defined for Integration Enhancements build
1097: lv_dl_std_code igf_ap_class_std_map.dl_std_code%TYPE;
1098: lv_cl_std_code igf_ap_class_std_map.dl_std_code%TYPE;