APPS.IGS_FI_CREDIT_PVT dependencies on IGS_FI_WAIVER_PGMS

Line 104: CURSOR cur_waiver_pgms (cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,

100: WHERE person_id = cp_person_id
101: AND application_id = cp_application_id;
102:
103: -- Cursor to get the waiver name, fee cal type for the passed waiver name
104: CURSOR cur_waiver_pgms (cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
105: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
106: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE ) IS
107: SELECT fwp.fee_cal_type, fwp.fee_ci_sequence_number, fwp.waiver_name
108: FROM igs_fi_waiver_pgms fwp

Line 105: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

101: AND application_id = cp_application_id;
102:
103: -- Cursor to get the waiver name, fee cal type for the passed waiver name
104: CURSOR cur_waiver_pgms (cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
105: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
106: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE ) IS
107: SELECT fwp.fee_cal_type, fwp.fee_ci_sequence_number, fwp.waiver_name
108: FROM igs_fi_waiver_pgms fwp
109: WHERE fwp.fee_cal_type = cp_fee_cal_type

Line 106: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE ) IS

102:
103: -- Cursor to get the waiver name, fee cal type for the passed waiver name
104: CURSOR cur_waiver_pgms (cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
105: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
106: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE ) IS
107: SELECT fwp.fee_cal_type, fwp.fee_ci_sequence_number, fwp.waiver_name
108: FROM igs_fi_waiver_pgms fwp
109: WHERE fwp.fee_cal_type = cp_fee_cal_type
110: AND fwp.fee_ci_sequence_number = cp_fee_ci_sequence_number

Line 108: FROM igs_fi_waiver_pgms fwp

104: CURSOR cur_waiver_pgms (cp_fee_cal_type igs_fi_waiver_pgms.fee_cal_type%TYPE,
105: cp_fee_ci_sequence_number igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
106: cp_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE ) IS
107: SELECT fwp.fee_cal_type, fwp.fee_ci_sequence_number, fwp.waiver_name
108: FROM igs_fi_waiver_pgms fwp
109: WHERE fwp.fee_cal_type = cp_fee_cal_type
110: AND fwp.fee_ci_sequence_number = cp_fee_ci_sequence_number
111: AND fwp.waiver_name = cp_waiver_name;
112: