APPS.IGS_FI_GEN_008 dependencies on IGS_EN_STDNT_PS_ATT

Line 1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

1061: RETURN l_std_balance;
1062:
1063: END get_std_balance;
1064:
1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,

Line 1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

1062:
1063: END get_std_balance;
1064:
1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,
1070: p_v_status OUT NOCOPY VARCHAR2,

Line 1083: CURSOR cur_chg(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1079: Who When What
1080: ***********************************************************************************************/
1081:
1082: -- Cursor for checking if the Charge exists
1083: CURSOR cur_chg(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1084: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1085: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1086: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1087: SELECT 'x'

Line 1084: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

1080: ***********************************************************************************************/
1081:
1082: -- Cursor for checking if the Charge exists
1083: CURSOR cur_chg(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1084: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1085: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1086: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1087: SELECT 'x'
1088: FROM igs_fi_fee_as_all

Line 1096: CURSOR cur_cntrct_rates(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1092: AND fee_ci_sequence_number = cp_n_fee_ci_seq
1093: AND s_transaction_type = 'ASSESSMENT';
1094:
1095: -- Cursor for checking if Contract Rates exist
1096: CURSOR cur_cntrct_rates(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1097: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1098: cp_v_fee_cat igs_fi_fee_cat.fee_cat%TYPE) IS
1099: SELECT 'x'
1100: FROM igs_fi_f_cat_fee_lbl_all lbl,

Line 1097: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

1093: AND s_transaction_type = 'ASSESSMENT';
1094:
1095: -- Cursor for checking if Contract Rates exist
1096: CURSOR cur_cntrct_rates(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1097: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1098: cp_v_fee_cat igs_fi_fee_cat.fee_cat%TYPE) IS
1099: SELECT 'x'
1100: FROM igs_fi_f_cat_fee_lbl_all lbl,
1101: igs_fi_fee_as_rt rt