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_PS_NSUS_RTN

Line 679: FROM igs_ps_nsus_rtn_dtl dtl,

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
682: AND rtn.uoo_id = cp_n_uoo_id
683: AND rtn.fee_type = cp_v_fee_type

Line 680: igs_ps_nsus_rtn rtn

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
682: AND rtn.uoo_id = cp_n_uoo_id
683: AND rtn.fee_type = cp_v_fee_type
684: ORDER BY dtl.offset_date;

Line 690: FROM igs_ps_nsus_rtn_dtl dtl,

686: -- Cursor to fetch retention schedules defined at Unit Section level.
687: -- This cursor is used when cur_ns_ft_ret does not find any rows
688: CURSOR cur_ns_usec_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
689: SELECT dtl.offset_date
690: FROM igs_ps_nsus_rtn_dtl dtl,
691: igs_ps_nsus_rtn rtn
692: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
693: AND rtn.uoo_id = cp_n_uoo_id
694: AND rtn.fee_type IS NULL

Line 691: igs_ps_nsus_rtn rtn

687: -- This cursor is used when cur_ns_ft_ret does not find any rows
688: CURSOR cur_ns_usec_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
689: SELECT dtl.offset_date
690: FROM igs_ps_nsus_rtn_dtl dtl,
691: igs_ps_nsus_rtn rtn
692: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
693: AND rtn.uoo_id = cp_n_uoo_id
694: AND rtn.fee_type IS NULL
695: ORDER BY dtl.offset_date;

Line 705: FROM igs_ps_nsus_rtn_dtl dtl,

701: rtn.formula_method,
702: rtn.round_method,
703: rtn.incl_wkend_duration_flag,
704: dtl.offset_value) offset_date
705: FROM igs_ps_nsus_rtn_dtl dtl,
706: igs_ps_nsus_rtn rtn
707: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
708: AND rtn.uoo_id IS NULL
709: AND rtn.fee_type IS NULL

Line 706: igs_ps_nsus_rtn rtn

702: rtn.round_method,
703: rtn.incl_wkend_duration_flag,
704: dtl.offset_value) offset_date
705: FROM igs_ps_nsus_rtn_dtl dtl,
706: igs_ps_nsus_rtn rtn
707: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
708: AND rtn.uoo_id IS NULL
709: AND rtn.fee_type IS NULL
710: ORDER BY offset_date;

Line 857: FROM igs_ps_nsus_rtn_dtl dtl,

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,
858: igs_ps_nsus_rtn rtn
859: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
860: AND rtn.uoo_id = cp_n_uoo_id
861: AND rtn.fee_type = cp_v_fee_type

Line 858: igs_ps_nsus_rtn rtn

854: SELECT dtl.offset_date,
855: dtl.retention_amount,
856: dtl.retention_percent
857: FROM igs_ps_nsus_rtn_dtl dtl,
858: igs_ps_nsus_rtn rtn
859: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
860: AND rtn.uoo_id = cp_n_uoo_id
861: AND rtn.fee_type = cp_v_fee_type
862: ORDER BY offset_date;

Line 870: FROM igs_ps_nsus_rtn_dtl dtl,

866: CURSOR cur_ns_usec_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
867: SELECT dtl.offset_date,
868: dtl.retention_amount,
869: dtl.retention_percent
870: FROM igs_ps_nsus_rtn_dtl dtl,
871: igs_ps_nsus_rtn rtn
872: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
873: AND rtn.uoo_id = cp_n_uoo_id
874: AND rtn.fee_type IS NULL

Line 871: igs_ps_nsus_rtn rtn

867: SELECT dtl.offset_date,
868: dtl.retention_amount,
869: dtl.retention_percent
870: FROM igs_ps_nsus_rtn_dtl dtl,
871: igs_ps_nsus_rtn rtn
872: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
873: AND rtn.uoo_id = cp_n_uoo_id
874: AND rtn.fee_type IS NULL
875: ORDER BY offset_date;

Line 887: FROM igs_ps_nsus_rtn_dtl dtl,

883: rtn.formula_method,
884: rtn.round_method,
885: rtn.incl_wkend_duration_flag,
886: dtl.offset_value) offset_date
887: FROM igs_ps_nsus_rtn_dtl dtl,
888: igs_ps_nsus_rtn rtn
889: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
890: AND rtn.uoo_id IS NULL
891: AND rtn.fee_type IS NULL

Line 888: igs_ps_nsus_rtn rtn

884: rtn.round_method,
885: rtn.incl_wkend_duration_flag,
886: dtl.offset_value) offset_date
887: FROM igs_ps_nsus_rtn_dtl dtl,
888: igs_ps_nsus_rtn rtn
889: WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
890: AND rtn.uoo_id IS NULL
891: AND rtn.fee_type IS NULL
892: ORDER BY offset_date;

Line 901: l_n_ret_amount igs_ps_nsus_rtn_dtl.retention_amount%TYPE := 0;

897: -- at the (Non Standard Unit Section + Fee Type) level or Unit Section level
898: -- or at the Institution level
899: l_b_ret_found BOOLEAN := FALSE;
900:
901: l_n_ret_amount igs_ps_nsus_rtn_dtl.retention_amount%TYPE := 0;
902: l_n_ret_percent igs_ps_nsus_rtn_dtl.retention_percent%TYPE := 0;
903: l_n_amount NUMBER := 0.0;
904:
905: BEGIN

Line 902: l_n_ret_percent igs_ps_nsus_rtn_dtl.retention_percent%TYPE := 0;

898: -- or at the Institution level
899: l_b_ret_found BOOLEAN := FALSE;
900:
901: l_n_ret_amount igs_ps_nsus_rtn_dtl.retention_amount%TYPE := 0;
902: l_n_ret_percent igs_ps_nsus_rtn_dtl.retention_percent%TYPE := 0;
903: l_n_amount NUMBER := 0.0;
904:
905: BEGIN
906: