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_GEN_002 dependencies on IGS_LOOKUP_VALUES

Line 3005: lOverallStatus igs_lookup_values.meaning%TYPE;

3001: *******************************************************************************/
3002: l_FeeAmt igs_ad_appl_all.appl_fee_amt%TYPE :=0;
3003: l_TotalRemitt igs_ad_app_req.fee_amount%TYPE :=0;
3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;
3005: lOverallStatus igs_lookup_values.meaning%TYPE;
3006: CURSOR c_adm_fee_amt IS
3007: SELECT appl_fee_amt
3008: FROM igs_ad_appl_all
3009: WHERE person_id = p_person_id

Line 3013: FROM igs_lookup_values

3009: WHERE person_id = p_person_id
3010: AND admission_appl_number = p_admission_appl_number;
3011: CURSOR c_appl_fee_status_meaning (p_sys_fee_status igs_ad_code_classes.class%TYPE) IS
3012: SELECT meaning
3013: FROM igs_lookup_values
3014: WHERE lookup_type = 'SYS_FEE_STATUS'
3015: AND lookup_code = p_sys_fee_status;
3016: CURSOR c_fee_amount IS
3017: SELECT req.fee_amount,