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.

[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_FEE_TYPE

Line 241: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,

237: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
238: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
239: p_v_fee_cat IN igs_fi_fee_as_items.fee_cat%TYPE,
240: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
241: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,
242: p_n_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
243: p_v_transaction_type IN igs_fi_inv_int_all.transaction_type%TYPE,
244: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
245: p_v_invoice_num OUT NOCOPY igs_fi_inv_int_all.invoice_number%TYPE,

Line 273: cp_fee_type igs_fi_fee_type.fee_type%TYPE,

269: cp_course_cd igs_ps_ver.course_cd%TYPE,
270: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
271: cp_fee_cat igs_fi_fee_as_items.fee_cat%TYPE,
272: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
273: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
274: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
275: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE) IS
276: SELECT inv.invoice_number
277: FROM igs_fi_inv_int inv,

Line 524: CURSOR cur_ret_special(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

520: AND ( (TRUNC(SYSDATE) <= TRUNC(end_dt)) OR (end_dt IS NULL) )
521: ORDER BY start_dt;
522:
523: -- Cursor to select retention records for Special Fee Types
524: CURSOR cur_ret_special(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
525: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
526: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
527: cp_v_relation_ftci VARCHAR2) IS
528: SELECT retention_percentage,

Line 540: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS

536: AND ( (TRUNC(SYSDATE) <= TRUNC(end_dt)) OR end_dt IS NULL)
537: ORDER BY start_dt;
538:
539: -- To determine System Fee Type of input Fee Type
540: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
541: SELECT s_fee_type
542: FROM igs_fi_fee_type
543: WHERE fee_type = cp_v_fee_type;
544:

Line 542: FROM igs_fi_fee_type

538:
539: -- To determine System Fee Type of input Fee Type
540: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
541: SELECT s_fee_type
542: FROM igs_fi_fee_type
543: WHERE fee_type = cp_v_fee_type;
544:
545: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE := NULL;
546:

Line 545: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE := NULL;

541: SELECT s_fee_type
542: FROM igs_fi_fee_type
543: WHERE fee_type = cp_v_fee_type;
544:
545: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE := NULL;
546:
547: l_n_ret_amount igs_fi_fee_ret_schd.retention_amount%TYPE := 0.0;
548: l_n_ret_percent igs_fi_fee_ret_schd.retention_percentage%TYPE := 0.0;
549:

Line 677: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS

673: AND TRUNC(dai_alias_val) <= TRUNC(cp_d_disc_dt);
674:
675: -- Cursor to fetch retention schedules defined at Unit Section + Fee Type level
676: CURSOR cur_ns_ft_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
677: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
678: SELECT dtl.offset_date
679: FROM igs_ps_nsus_rtn_dtl dtl,
680: igs_ps_nsus_rtn rtn
681: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id

Line 831: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,

827:
828: END get_complete_withdr_ret_amt;
829:
830: FUNCTION get_ns_usec_retention(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
831: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE,
832: p_d_effective_date IN DATE,
833: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
834: /**************************************************************************
835: Created By : Priya Athipatla

Line 853: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS

849: ns_usec_retention_tbl ns_usec_retention_tbl_typ;
850:
851: -- Cursor to fetch retention schedules defined at Unit Section + Fee Type level
852: CURSOR cur_ns_ft_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
853: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
854: SELECT dtl.offset_date,
855: dtl.retention_amount,
856: dtl.retention_percent
857: FROM igs_ps_nsus_rtn_dtl dtl,