APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_WAV_STD_PGMS

Line 605: FROM igs_fi_wav_std_pgms

601: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
602: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
603: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
604: SELECT assignment_status_code
605: FROM igs_fi_wav_std_pgms
606: WHERE person_id = cp_n_person_id
607: AND fee_cal_type = cp_v_fee_cal_type
608: AND fee_ci_sequence_number = cp_n_fee_ci_seq
609: AND waiver_name = cp_v_waiver_name;

Line 634: l_v_assgn_stat_code igs_fi_wav_std_pgms.assignment_status_code%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;
637: BEGIN
638:

Line 1614: FROM IGS_FI_WAV_STD_PGMS FWSP,

1610: IS
1611: SELECT FWSP.WAIVER_NAME,
1612: FWSP.PERSON_ID,
1613: FWP.TARGET_FEE_TYPE
1614: FROM IGS_FI_WAV_STD_PGMS FWSP,
1615: IGS_FI_WAIVER_PGMS FWP
1616: WHERE FWSP.FEE_CAL_TYPE = cp_v_fee_cal_type
1617: AND FWSP.FEE_CI_SEQUENCE_NUMBER = cp_n_fee_ci_seq_nbr
1618: AND (cp_v_waiver_name IS NULL OR FWSP.WAIVER_NAME = cp_v_waiver_name)