DBA Data[Home] [Help]

APPS.IGF_SP_GEN_001 dependencies on IGS_FI_GEN_007

Line 150: SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id

146: CURSOR cur_waiver_credit(cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
147: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
148: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE)
149: IS
150: SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id
151: FROM igs_fi_applications appl,
152: igs_fi_credits_all crd,
153: igs_fi_cr_types_all cr
154: WHERE appl.invoice_id = cp_n_invoice_id