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.IGF_AP_GEN_001 dependencies on IGS_CA_TYPE

Line 301: igs_ca_type cty

297: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
298: TRUNC(ci.end_dt) enrolled_end_dt
299: FROM
300: igs_ca_inst ci,
301: igs_ca_type cty
302: WHERE cty.s_cal_cat = 'LOAD'
303: AND cty.cal_type = ci.cal_type
304: AND (ci.cal_type, ci.sequence_number)IN
305: (SELECT sup_cal_type,

Line 328: igs_ca_type cty

324: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
325: TRUNC(ci.end_dt) enrolled_end_dt
326: FROM
327: igs_ca_inst ci,
328: igs_ca_type cty
329: WHERE cty.s_cal_cat = 'LOAD'
330: AND cty.cal_type = ci.cal_type
331: AND (ci.cal_type, ci.sequence_number)IN
332: (SELECT sup_cal_type,