APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_INV_WAV_DET

Line 231: FROM igs_fi_inv_wav_det

227: AND fee_ci_sequence_number = p_fee_ci_sequence_number
228: AND TRUNC(invoice_creation_date) <= TRUNC(p_process_start_date)
229: AND person_id = p_person_id
230: AND NOT EXISTS (SELECT 'X'
231: FROM igs_fi_inv_wav_det
232: WHERE invoice_id = inv.invoice_id
233: AND balance_type = 'HOLDS'
234: AND (
235: (

Line 261: igs_fi_inv_wav_det wav

257: -- Added as part of Bug# 3192641
258: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS
259: SELECT NVL(SUM(chg.invoice_amount), 0)
260: FROM igs_fi_inv_int_all chg,
261: igs_fi_inv_wav_det wav
262: WHERE person_id = cp_n_person_id
263: AND chg.invoice_id = wav.invoice_id
264: AND wav.balance_type = 'HOLDS'
265: AND cp_d_process_start_date BETWEEN TRUNC(start_dt) AND NVL(TRUNC(end_dt), cp_d_process_start_date);

Line 1753: FROM igs_fi_inv_wav_det

1749: AND TRUNC(invoice_creation_date) <= TRUNC(l_process_start_dt)
1750: AND person_id = p_person_id
1751: AND NVL(invoice_amount_due,0) > 0
1752: AND NOT EXISTS ( SELECT 'X'
1753: FROM igs_fi_inv_wav_det
1754: WHERE invoice_id = inv.invoice_id
1755: AND balance_type = 'HOLDS'
1756: AND ( (TRUNC(end_dt) IS NOT NULL AND TRUNC(SYSDATE) BETWEEN TRUNC(start_dt) AND TRUNC(end_dt))
1757: OR

Line 1789: igs_fi_inv_wav_det wav

1785: -- Added as part of Bug# 3192641
1786: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS
1787: SELECT NVL(SUM(chg.invoice_amount), 0)
1788: FROM igs_fi_inv_int_all chg,
1789: igs_fi_inv_wav_det wav
1790: WHERE person_id = cp_n_person_id
1791: AND chg.invoice_id = wav.invoice_id
1792: AND wav.balance_type = 'HOLDS'
1793: AND cp_d_process_start_date BETWEEN TRUNC(start_dt) AND NVL(TRUNC(end_dt), cp_d_process_start_date);