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_PRC_WAIVERS dependencies on IGS_FI_CONTROL

Line 613: FROM igs_fi_control;

609: AND waiver_name = cp_v_waiver_name;
610:
611: CURSOR cur_ctrl IS
612: SELECT NVL(waiver_notify_finaid_flag,'N') waiver_notify_finaid_flag
613: FROM igs_fi_control;
614:
615: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
616: l_v_message_name VARCHAR2(2000);
617: l_v_ret_status VARCHAR2(1);

Line 615: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;

611: CURSOR cur_ctrl IS
612: SELECT NVL(waiver_notify_finaid_flag,'N') waiver_notify_finaid_flag
613: FROM igs_fi_control;
614:
615: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
616: l_v_message_name VARCHAR2(2000);
617: l_v_ret_status VARCHAR2(1);
618:
619: l_n_old_wav_amnt igs_fi_credits_all.amount%TYPE;

Line 632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;

628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:
632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;
633: l_n_tot_wav_amnt igs_fi_credits_all.amount%TYPE;
634: l_v_assgn_stat_code igs_fi_wav_std_pgms.assignment_status_code%TYPE;
635:
636: l_n_prc_cnt NUMBER;

Line 1555: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;

1551:
1552: l_n_person_id hz_parties.party_id%TYPE;
1553: l_dynamic_sql VARCHAR2(32767);
1554: l_v_status VARCHAR2(1);
1555: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
1556: l_v_message_name fnd_new_messages.message_name%TYPE;
1557:
1558: -- Out Parameters from the Process_Waivers procedure.
1559: l_b_recs_found BOOLEAN;

Line 1567: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;

1563: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1564: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1565: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1566:
1567: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;
1568: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1569: l_d_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
1570: l_n_version_number igs_fi_balance_rules.version_number%TYPE;
1571: l_msg VARCHAR2(2000);

Line 1602: FROM IGS_FI_CONTROL;

1598:
1599: CURSOR cur_get_currency_cd
1600: IS
1601: SELECT currency_cd
1602: FROM IGS_FI_CONTROL;
1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;
1604:
1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,

Line 1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;

1599: CURSOR cur_get_currency_cd
1600: IS
1601: SELECT currency_cd
1602: FROM IGS_FI_CONTROL;
1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;
1604:
1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,