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_AD_ADM_REQ dependencies on IGS_AD_PS_APPL_INST

Line 72: igs_ad_ps_appl_inst apai,

68: apai.admission_appl_number,
69: apai.nominated_course_cd,
70: apai.sequence_number
71: FROM
72: igs_ad_ps_appl_inst apai,
73: igs_ad_ou_stat aos,
74: igs_ad_doc_stat ads,
75: igs_ad_appl aa,
76: igs_ad_appl_stat aps

Line 121: igs_ad_ps_appl_inst apai,

117: apai.admission_appl_number,
118: apai.nominated_course_cd,
119: apai.sequence_number
120: FROM
121: igs_ad_ps_appl_inst apai,
122: igs_ad_ou_stat aos,
123: igs_ad_doc_stat ads,
124: igs_ad_appl aa,
125: igs_ad_appl_stat aps

Line 433: igs_ad_ps_appl_inst apai,

429: IGS_CA_GEN_002.cals_clc_dt_from_dai(
430: cdi.ci_sequence_number, cdi.CAL_TYPE, cdi.DT_ALIAS, cdi.sequence_number)
431: )), TRUNC(sysdate-1)) alias_val
432: FROM
433: igs_ad_ps_appl_inst apai,
434: igs_ad_cal_conf acc,
435: igs_ca_da_inst cdi
436: WHERE
437: -- Application Instance

Line 483: igs_ad_ps_appl_inst apai,

479: aa.admission_cat,
480: aa.s_admission_process_type,
481: apai.crv_version_number
482: FROM
483: igs_ad_ps_appl_inst apai,
484: igs_ad_appl aa
485: WHERE
486: apai.person_id = aa.person_id AND
487: apai.admission_appl_number = aa.admission_appl_number AND

Line 502: igs_ad_ps_appl_inst apai,

498: WHERE ty.s_tracking_type = p_requirements_type
499: AND ty.closed_ind = 'N'
500: AND EXISTS ( SELECT 'X'
501: FROM igs_ad_appl aa,
502: igs_ad_ps_appl_inst apai,
503: igs_ad_prcs_cat_step apcs
504: WHERE apai.person_id = p_person_id
505: AND apai.admission_appl_number = p_admission_appl_number
506: AND apai.sequence_number = p_sequence_number