eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GEN_008 dependencies on IGS_EN_SU_ATTEMPT

Line 594: FUNCTION get_complete_withdr_ret_amt( p_n_person_id IN igs_en_su_attempt.person_id%TYPE,

590:
591: END get_fee_retention_amount;
592:
593:
594: FUNCTION get_complete_withdr_ret_amt( p_n_person_id IN igs_en_su_attempt.person_id%TYPE,
595: p_v_course_cd IN igs_en_su_attempt.course_cd%TYPE,
596: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
597: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
598: p_n_diff_amount IN NUMBER,

Line 595: p_v_course_cd IN igs_en_su_attempt.course_cd%TYPE,

591: END get_fee_retention_amount;
592:
593:
594: FUNCTION get_complete_withdr_ret_amt( p_n_person_id IN igs_en_su_attempt.person_id%TYPE,
595: p_v_course_cd IN igs_en_su_attempt.course_cd%TYPE,
596: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
597: p_n_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
598: p_n_diff_amount IN NUMBER,
599: p_v_fee_type IN igs_fi_f_typ_ca_inst_all.fee_type%TYPE,

Line 635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,

631: Bug#4304524 Registration Fee Retention not working for the first date of Retention.
632: Modified the cursor cur_tp_ret
633: **************************************************************************/
634:
635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,
637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE

Line 636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,

632: Modified the cursor cur_tp_ret
633: **************************************************************************/
634:
635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,
637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE
640: ) IS

Line 642: FROM igs_en_su_attempt sua,

638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE
640: ) IS
641: SELECT sua.*, usec.non_std_usec_ind
642: FROM igs_en_su_attempt sua,
643: igs_ps_unit_ofr_opt usec
644: WHERE sua.person_id = cp_n_person_id
645: AND sua.course_cd = cp_v_course_cd
646: AND usec.uoo_id = sua.uoo_id

Line 665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS

661: -- Cursor to fetch Retention Schedules defined at Teaching Period level
662: -- Also to filter based on the Discontinued Date.
663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS
666: SELECT 'X'
667: FROM igs_fi_tp_ret_schd_v
668: WHERE teach_cal_type = cp_v_teach_cal_type
669: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num