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_CREATE_GENERIC_PKG dependencies on IGS_CA_TYPE

Line 2494: igs_ca_type cat

2490:
2491: CURSOR cur_exam_cal(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
2492: SELECT 'X'
2493: FROM igs_ca_inst ci,
2494: igs_ca_type cat
2495: WHERE cat.s_cal_cat = 'EXAM'
2496: AND ci.cal_type = cat.cal_type
2497: AND ci.cal_type = cp_cal_type
2498: AND ci.sequence_number = cp_sequence_number

Line 7694: igs_ca_type ct,

7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,
7692: igs_fi_f_typ_ca_inst ftci,
7693: igs_ca_inst ci,
7694: igs_ca_type ct,
7695: igs_ca_stat cs
7696: WHERE ft.s_fee_type = 'SPECIAL'
7697: AND ft.closed_ind = 'N'
7698: AND ft.fee_type = ftci.fee_type

Line 10352: igs_ca_type ct,

10348: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
10349: FROM igs_fi_fee_type ft,
10350: igs_fi_f_typ_ca_inst ftci,
10351: igs_ca_inst ci,
10352: igs_ca_type ct,
10353: igs_ca_stat cs
10354: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')
10355: AND ft.closed_ind = 'N'
10356: AND ft.fee_type = ftci.fee_type