DBA Data[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_FI_INV_WAV_DET

Line 360: FROM igs_fi_inv_wav_det wd

356: AND hd.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
357: AND ln.uoo_id IS NOT NULL
358: AND hd.course_cd IS NOT NULL
359: AND NOT EXISTS (SELECT 'X'
360: FROM igs_fi_inv_wav_det wd
361: WHERE wd.invoice_id = hd.invoice_id
362: AND wd.balance_type = cp_v_balance_type
363: AND (wd.end_dt is not null AND sysdate
364: BETWEEN wd.start_dt and wd.end_dt))

Line 395: FROM igs_fi_inv_wav_det wd

391: AND hd.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
392: AND ln.uoo_id IS NOT NULL
393: AND hd.course_cd IS NOT NULL
394: AND NOT EXISTS (SELECT 'X'
395: FROM igs_fi_inv_wav_det wd
396: WHERE wd.invoice_id = hd.invoice_id
397: AND wd.balance_type = cp_v_balance_type
398: AND (wd.end_dt is not null AND sysdate
399: BETWEEN wd.start_dt and wd.end_dt))

Line 426: FROM igs_fi_inv_wav_det wd

422: AND hd.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
423: AND ln.uoo_id IS NOT NULL
424: AND hd.course_cd IS NOT NULL
425: AND NOT EXISTS (SELECT 'X'
426: FROM igs_fi_inv_wav_det wd
427: WHERE wd.invoice_id = hd.invoice_id
428: AND wd.balance_type = cp_v_balance_type
429: AND (wd.end_dt is not null AND sysdate
430: BETWEEN wd.start_dt and wd.end_dt))