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_EN_WLST_GEN_PROC dependencies on IGS_EN_ORUN_WLST_PRF

Line 1141: FROM igs_en_orun_wlst_prf

1137: -- Cursor to select preferences for a given priority Id at organizational unit level
1138: CURSOR cur_wlst_org_prf ( cp_priority_id igs_en_orun_wlst_pri.org_unit_wlst_pri_id%TYPE)
1139: IS
1140: SELECT preference_code,preference_version
1141: FROM igs_en_orun_wlst_prf
1142: WHERE org_unit_wlst_pri_id = cp_priority_id
1143: ORDER BY preference_order;
1144:
1145: -- Cursor to select maximum number of priorities at organizational unit level

Line 1162: FROM igs_en_orun_wlst_prf

1158: CURSOR cur_max_org_prf ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1159: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1160: IS
1161: SELECT count(org_unit_wlst_prf_id)
1162: FROM igs_en_orun_wlst_prf
1163: WHERE org_unit_wlst_pri_id IN(SELECT owp.org_unit_wlst_pri_id
1164: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1165: WHERE ouw.org_unit_cd = cp_org_unit_cd
1166: AND ouw.cal_type = cp_cal_type