APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_FEE_TYPE

Line 42: p_v_fee_type igs_fi_fee_type.fee_type%TYPE,

38:
39:
40: FUNCTION validate_params(p_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
41: p_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
42: p_v_fee_type igs_fi_fee_type.fee_type%TYPE,
43: p_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) RETURN BOOLEAN AS
44:
45: /******************************************************************
46: Created By : Amit Gairola

Line 61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

57: ***************************************************************** */
58:
59: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
63: SELECT waiver_name
64: FROM igs_fi_waiver_pgms
65: WHERE target_fee_type = cp_v_fee_type

Line 427: p_v_target_fee_type igs_fi_fee_type.fee_type%TYPE,

423: PROCEDURE get_calc_new_waiver_amt(p_n_person_id NUMBER,
424: p_v_fee_cal_type VARCHAR2,
425: p_n_fee_ci_seq_number NUMBER,
426: p_v_waiver_name VARCHAR2,
427: p_v_target_fee_type igs_fi_fee_type.fee_type%TYPE,
428: p_v_rule_fee_type igs_fi_fee_type.fee_type%TYPE,
429: p_v_wav_criteria_code VARCHAR2,
430: p_n_wav_per_alloc NUMBER,
431: p_d_gl_date DATE,

Line 428: p_v_rule_fee_type igs_fi_fee_type.fee_type%TYPE,

424: p_v_fee_cal_type VARCHAR2,
425: p_n_fee_ci_seq_number NUMBER,
426: p_v_waiver_name VARCHAR2,
427: p_v_target_fee_type igs_fi_fee_type.fee_type%TYPE,
428: p_v_rule_fee_type igs_fi_fee_type.fee_type%TYPE,
429: p_v_wav_criteria_code VARCHAR2,
430: p_n_wav_per_alloc NUMBER,
431: p_d_gl_date DATE,
432: p_v_real_time_flag VARCHAR2,

Line 590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

586: ***************************************************************** */
587:
588: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
592: SELECT fwp.*
593: FROM igs_fi_waiver_pgms fwp
594: WHERE fwp.target_fee_type = cp_v_fee_type

Line 1020: CURSOR cur_wav_pgms(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

1016: Who When What
1017:
1018: ***************************************************************** */
1019:
1020: CURSOR cur_wav_pgms(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1021: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
1022: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
1023: SELECT fwp.fee_cal_type,
1024: fwp.fee_ci_sequence_number,

Line 1630: FROM IGS_FI_FEE_TYPE_ALL FT

1626:
1627: CURSOR cur_get_sys_fee_type(cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1628: IS
1629: SELECT FT.S_FEE_TYPE
1630: FROM IGS_FI_FEE_TYPE_ALL FT
1631: WHERE FT.FEE_TYPE = cp_v_target_fee_type;
1632:
1633: l_cur_v_target_fee_type cur_get_sys_fee_type%ROWTYPE;
1634: l_b_flag BOOLEAN;