APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_FEE_TYPE_ALL

Line 219: CURSOR c_invoice_amnt(l_fee_type igs_fi_fee_type_all.fee_type%TYPE ) IS

215: ORDER BY crd.credit_id ;
216:
217:
218: --to SELECT invoice amount or invoice amount due based on the l_SELECT_facto value passed
219: CURSOR c_invoice_amnt(l_fee_type igs_fi_fee_type_all.fee_type%TYPE ) IS
220: SELECT invoice_id,
221: invoice_amount amount,
222: invoice_amount_due ,
223: invoice_creation_date

Line 1734: l_c_fee_type igs_fi_fee_type_all.fee_type%TYPE;

1730: SELECT fee_type
1731: FROM igs_fi_hold_plan fhpl
1732: WHERE fhpl.hold_plan_name = cp_c_hold_plan_name;
1733:
1734: l_c_fee_type igs_fi_fee_type_all.fee_type%TYPE;
1735:
1736: CURSOR c_total_balance(l_fee_cal_type igs_fi_person_holds.fee_cal_type%TYPE,
1737: l_fee_ci_sequence_number igs_fi_person_holds.fee_ci_sequence_number%TYPE,
1738: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE,

Line 1739: cp_c_fee_type igs_fi_fee_type_all.fee_type%TYPE

1735:
1736: CURSOR c_total_balance(l_fee_cal_type igs_fi_person_holds.fee_cal_type%TYPE,
1737: l_fee_ci_sequence_number igs_fi_person_holds.fee_ci_sequence_number%TYPE,
1738: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE,
1739: cp_c_fee_type igs_fi_fee_type_all.fee_type%TYPE
1740: ) IS
1741: SELECT invoice_id,
1742: invoice_amount_due,
1743: invoice_creation_date,