APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_FI_INV_WAV_DET_V

Line 240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;

236:
237: l_start_dt igs_fi_inv_wav_det.start_dt%TYPE ;
238: l_end_dt igs_fi_inv_wav_det.end_dt%TYPE ;
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;
242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;
243: l_per_num igs_pe_person_v.person_number%TYPE ;
244: l_msg_str VARCHAR2(1000) ;

Line 322: FROM igs_fi_inv_wav_det_v

318: CURSOR c_chg_wav (cp_inv_id igs_fi_inv_wav_det.invoice_id%TYPE ,
319: cp_bal_type igs_fi_inv_wav_det.balance_type%TYPE ,
320: cp_rel_dt igs_fi_inv_wav_det.end_dt%TYPE) IS
321: SELECT *
322: FROM igs_fi_inv_wav_det_v
323: WHERE invoice_id = cp_inv_id
324: AND balance_type = cp_bal_type
325: AND ((end_dt IS NOT NULL AND end_dt > cp_rel_dt) OR (end_dt IS NULL));
326: