DBA Data[Home] [Help]

APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_INVLN_INT

Line 45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
47: x_return_status OUT NOCOPY VARCHAR2) AS
48: /******************************************************************
49: Created By : Umesh Udayaprakash

Line 218: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

214: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
215: p_n_credit_type_id IN igs_fi_credits.credit_id%TYPE,
216: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
217: p_n_waiver_amt IN NUMBER,
218: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
219: p_n_credit_id OUT NOCOPY NUMBER,
220: x_return_status OUT NOCOPY VARCHAR2) AS
221: /******************************************************************
222: Created By : Umesh Udayaprakash

Line 1269: igs_fi_invln_int invln

1265: cp_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
1266: cp_n_fee_ci_seq igs_fi_inv_int.fee_ci_sequence_number%TYPE) IS
1267: SELECT 'x'
1268: FROM igs_fi_inv_int inv,
1269: igs_fi_invln_int invln
1270: WHERE inv.person_id = cp_n_person_id
1271: AND inv.fee_type = cp_v_fee_type
1272: AND inv.fee_cal_type = cp_v_fee_cal_type
1273: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq