eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_FI_F_TYP_CA_INST

Line 53: CURSOR cur_perd(cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

49: --Change History:
50: --Who When What
51: -------------------------------------------------------------------
52:
53: CURSOR cur_perd(cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
54: cp_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
55: SELECT cal_type , start_dt , end_dt
56: FROM igs_ca_inst
57: WHERE cal_type = cp_cal_type

Line 54: cp_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

50: --Who When What
51: -------------------------------------------------------------------
52:
53: CURSOR cur_perd(cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
54: cp_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
55: SELECT cal_type , start_dt , end_dt
56: FROM igs_ca_inst
57: WHERE cal_type = cp_cal_type
58: AND sequence_number = cp_seq_num;

Line 241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;

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) ;
245:

Line 242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%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) ;
245:
246: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;

Line 270: CURSOR c_cal_per (cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,

266: AND pp.party_id = cp_n_person_id;
267:
268: l_v_per_id c_per_id%ROWTYPE;
269:
270: CURSOR c_cal_per (cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
271: cp_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
272: SELECT 'X'
273: FROM igs_ca_type t , igs_ca_inst i , igs_ca_stat s
274: WHERE t.closed_ind = 'N'

Line 271: cp_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

267:
268: l_v_per_id c_per_id%ROWTYPE;
269:
270: CURSOR c_cal_per (cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
271: cp_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
272: SELECT 'X'
273: FROM igs_ca_type t , igs_ca_inst i , igs_ca_stat s
274: WHERE t.closed_ind = 'N'
275: AND t.s_cal_cat = 'FEE'

Line 299: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,

295: WHERE party_id = cp_person_id
296: AND party_type IN ('ORGANIZATION','PERSON');
297:
298: CURSOR c_per_chg (cp_person_id igs_pe_person_v.person_id%TYPE ,
299: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
300: cp_fee_ci_seq_no igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,
301: /* Removed the cursor parameters cp_sub_acc1 and cp_sub_acc2 as a part of the Bug # 2564643 */
302: cp_fee_type1 igs_fi_inv_int.fee_type%TYPE ,
303: cp_fee_type2 igs_fi_inv_int.fee_type%TYPE ,

Line 300: cp_fee_ci_seq_no igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,

296: AND party_type IN ('ORGANIZATION','PERSON');
297:
298: CURSOR c_per_chg (cp_person_id igs_pe_person_v.person_id%TYPE ,
299: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
300: cp_fee_ci_seq_no igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,
301: /* Removed the cursor parameters cp_sub_acc1 and cp_sub_acc2 as a part of the Bug # 2564643 */
302: cp_fee_type1 igs_fi_inv_int.fee_type%TYPE ,
303: cp_fee_type2 igs_fi_inv_int.fee_type%TYPE ,
304: cp_fee_type3 igs_fi_inv_int.fee_type%TYPE) IS