APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_INVLN_INT_ALL

Line 408: igs_fi_invln_int_all invln

404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
405: SELECT inv.invoice_id,
406: inv.invoice_amount_due
407: FROM igs_fi_inv_int_all inv,
408: igs_fi_invln_int_all invln
409: WHERE inv.person_id = cp_n_person_id
410: AND inv.fee_type = cp_v_target_fee_type
411: AND inv.fee_cal_type = cp_v_fee_cal_type
412: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 965: igs_fi_invln_int_all invln

961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
962: SELECT inv.invoice_id,
963: inv.invoice_amount_due
964: FROM igs_fi_inv_int_all inv,
965: igs_fi_invln_int_all invln
966: WHERE inv.person_id = cp_n_person_id
967: AND inv.fee_type = cp_v_adj_fee_type
968: AND inv.fee_cal_type = cp_v_fee_cal_type
969: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1100: igs_fi_invln_int_all invln

1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1097: SELECT inv.invoice_id,
1098: inv.invoice_amount_due
1099: FROM igs_fi_inv_int_all inv,
1100: igs_fi_invln_int_all invln
1101: WHERE (inv.invoice_id = cp_n_invoice_id OR cp_n_invoice_id IS NULL)
1102: AND inv.person_id = cp_n_person_id
1103: AND inv.fee_type = cp_v_target_fee_type
1104: AND inv.fee_cal_type = cp_v_fee_cal_type

Line 1527: igs_fi_invln_int_all invln

1523: inv.invoice_id,
1524: inv.invoice_amount,
1525: inv.invoice_amount_due
1526: FROM igs_fi_inv_int_all inv,
1527: igs_fi_invln_int_all invln
1528: WHERE inv.person_id = cp_n_person_id
1529: AND inv.fee_type = cp_v_adj_fee_type
1530: AND inv.fee_cal_type = cp_v_fee_cal_type
1531: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,

1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
1853: x_return_status OUT NOCOPY VARCHAR2) IS
1854: /******************************************************************
1855: Created By : Priya Athipatla
1856: Date Created By : 16-Aug-2005