DBA Data[Home] [Help]

APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_INV_WAV_DET

Line 194: FROM igs_fi_inv_wav_det fiw

190: AND ((p_action = l_for_baldate AND TRUNC(inv.invoice_creation_date) = TRUNC(p_balance_date))
191: OR (p_action = l_as_on_baldate AND TRUNC(inv.invoice_creation_date) <= TRUNC(NVL(p_balance_date,sysdate)))
192: )
193: AND NOT EXISTS ( SELECT '1'
194: FROM igs_fi_inv_wav_det fiw
195: WHERE fiw.invoice_id = inv.invoice_id
196: AND fiw.balance_type = p_balance_type
197: AND p_balance_type = 'FEE'
198: AND ((fiw.end_dt IS NOT NULL AND p_balance_date BETWEEN fiw.start_dt AND fiw.end_dt)