APPS.IGF_SP_AWARD dependencies on IGS_CA_INST_ALL

Line 517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

513: -- cursor to check forprg attempt
514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt
521: WHERE person_id = cp_person_id

Line 518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt
521: WHERE person_id = cp_person_id
522: AND course_cd = cp_course_cd

Line 544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;

540: l_msg_count NUMBER;
541: l_msg_data VARCHAR2(2000);
542: l_status BOOLEAN;
543:
544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

Line 545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;

541: l_msg_data VARCHAR2(2000);
542: l_status BOOLEAN;
543:
544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;