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_PS_GEN_001 dependencies on IGS_FI_FEE_TYPE

Line 2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS

2326: SELECT *
2327: FROM igs_ps_uso_facility
2328: WHERE unit_section_occurrence_id = cp_unit_section_occurrence_id;
2329:
2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
2331: SELECT ci.cal_type,ci.sequence_number
2332: FROM igs_fi_fee_type ft,
2333: igs_fi_f_typ_ca_inst ftci,
2334: igs_ca_inst ci,

Line 2332: FROM igs_fi_fee_type ft,

2328: WHERE unit_section_occurrence_id = cp_unit_section_occurrence_id;
2329:
2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
2331: SELECT ci.cal_type,ci.sequence_number
2332: FROM igs_fi_fee_type ft,
2333: igs_fi_f_typ_ca_inst ftci,
2334: igs_ca_inst ci,
2335: igs_ca_type ct,
2336: igs_ca_stat cs

Line 3978: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS

3974: AND fee_type = cp_c_fee_type
3975: AND ROWNUM = 1;
3976: l_cur_usec_spl_fees_new cur_usec_spl_fees_new%ROWTYPE;
3977:
3978: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
3979: SELECT ci.cal_type,ci.sequence_number
3980: FROM igs_fi_fee_type ft,
3981: igs_fi_f_typ_ca_inst ftci,
3982: igs_ca_inst ci,

Line 3980: FROM igs_fi_fee_type ft,

3976: l_cur_usec_spl_fees_new cur_usec_spl_fees_new%ROWTYPE;
3977:
3978: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
3979: SELECT ci.cal_type,ci.sequence_number
3980: FROM igs_fi_fee_type ft,
3981: igs_fi_f_typ_ca_inst ftci,
3982: igs_ca_inst ci,
3983: igs_ca_type ct,
3984: igs_ca_stat cs