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_AD_UPD_INITIALISE dependencies on IGS_AD_APPL_ALL

Line 511: igs_ad_appl_all apl

507: FROM
508: igs_ca_inst_rel car , -- calendar relations table
509: igs_ca_inst_all ca , -- calendar instances table
510: igs_ca_type cat, -- calendar types table
511: igs_ad_appl_all apl
512: WHERE
513: apl.person_id = p_person_id -- current person id
514: AND apl.admission_appl_number = p_admission_appl_number -- current adm appl number
515: AND car.sup_cal_type = apl.adm_cal_type

Line 547: FROM igs_ad_appl_all apl ,

543: IS
544: SELECT apl.adm_cal_type,
545: apl.adm_ci_sequence_number ,
546: ca.start_dt
547: FROM igs_ad_appl_all apl ,
548: igs_ad_ps_appl_inst_all inst,
549: igs_ca_inst_all ca
550: WHERE apl.person_id = P_PERSON_ID
551: AND apl.person_id = inst.person_id