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.

[Home] [Help]

APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_FI_INV_INT

Line 188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,

184: p_n_person_id IN igs_pe_person_v.person_id%TYPE ,
185: p_n_pers_id_grp_id IN igs_pe_persid_group_v.group_id%TYPE ,
186: p_c_fee_period IN VARCHAR2 ,
187: /* Removed the parameters p_n_sub_acc_1 and p_n_sub_acc_2, as a part of Bug # 2564643 */
188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,
189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,
190: p_c_fee_type_3 IN igs_fi_inv_int.fee_type%TYPE ,
191: p_c_test_flag IN fnd_lookup_values.lookup_code%TYPE
192: ) AS

Line 189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,

185: p_n_pers_id_grp_id IN igs_pe_persid_group_v.group_id%TYPE ,
186: p_c_fee_period IN VARCHAR2 ,
187: /* Removed the parameters p_n_sub_acc_1 and p_n_sub_acc_2, as a part of Bug # 2564643 */
188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,
189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,
190: p_c_fee_type_3 IN igs_fi_inv_int.fee_type%TYPE ,
191: p_c_test_flag IN fnd_lookup_values.lookup_code%TYPE
192: ) AS
193: ------------------------------------------------------------------

Line 190: p_c_fee_type_3 IN igs_fi_inv_int.fee_type%TYPE ,

186: p_c_fee_period IN VARCHAR2 ,
187: /* Removed the parameters p_n_sub_acc_1 and p_n_sub_acc_2, as a part of Bug # 2564643 */
188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,
189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,
190: p_c_fee_type_3 IN igs_fi_inv_int.fee_type%TYPE ,
191: p_c_test_flag IN fnd_lookup_values.lookup_code%TYPE
192: ) AS
193: ------------------------------------------------------------------
194: --Created by : Jabeen Begum, Oracle IDC

Line 206: -- so that full table scan on IGS_FI_INV_INT_ALL can be avoided.

202: --Change History:
203: --Who When What
204: --sapanigr 30-May-2006 Bug 5251760 - Modified cursor c_per_id by replacing igs_fi_parties_v with base tables
205: --sapanigr 17-Feb-2006 Bug 5018036 - 1. Added validation to check if both person id and person id group are not null
206: -- so that full table scan on IGS_FI_INV_INT_ALL can be avoided.
207: -- 2. Broke up UNION in cursor c_person to make two different cursors c_person and c_pers_group.
208: -- This solves Non mergability issue and has improved performance.
209: --pathipat 26-Apr-2004 Bug 3578249 - Modified code w.r.t p_c_test_flag - Checked against Y and N
210: -- instead of against 1 and 2 respectively due to change in lookup_type used.

Line 302: cp_fee_type1 igs_fi_inv_int.fee_type%TYPE ,

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
305: SELECT *
306: FROM igs_fi_inv_int

Line 303: cp_fee_type2 igs_fi_inv_int.fee_type%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
305: SELECT *
306: FROM igs_fi_inv_int
307: WHERE person_id = cp_person_id

Line 304: cp_fee_type3 igs_fi_inv_int.fee_type%TYPE) IS

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
305: SELECT *
306: FROM igs_fi_inv_int
307: WHERE person_id = cp_person_id
308: AND fee_cal_type = cp_fee_cal_type

Line 306: FROM igs_fi_inv_int

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
305: SELECT *
306: FROM igs_fi_inv_int
307: WHERE person_id = cp_person_id
308: AND fee_cal_type = cp_fee_cal_type
309: AND fee_ci_sequence_number = cp_fee_ci_seq_no
310: AND transaction_type <>'REFUND'