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_EN_PRC_LOAD dependencies on IGS_AD_ADM_UT_STT_LD

Line 1450: FROM IGS_AD_ADM_UT_STT_LD AUSL

1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1447: cp_administrative_unit_status
1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1449: SELECT AUSL.load_incurred_ind
1450: FROM IGS_AD_ADM_UT_STT_LD AUSL
1451: WHERE AUSL.cal_type = cp_load_cal_type AND
1452: AUSL.ci_sequence_number = cp_load_sequence_number AND
1453: AUSL.teach_cal_type = cp_cal_type AND
1454: AUSL.administrative_unit_status = cp_administrative_unit_status;

Line 1472: v_load_incurred_ind IGS_AD_ADM_UT_STT_LD.load_incurred_ind%TYPE;

1468: SELECT include_waitlist_cp_flag
1469: FROM IGS_EN_INST_WL_STPS;
1470:
1471: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1472: v_load_incurred_ind IGS_AD_ADM_UT_STT_LD.load_incurred_ind%TYPE;
1473: v_start_dt IGS_CA_INST.start_dt%TYPE;
1474: v_end_dt IGS_CA_INST.end_dt%TYPE;
1475: v_dummy_aus VARCHAR2(10);
1476: v_admin_unit_status_str VARCHAR2(2000);

Line 1487: -- it checks the IGS_AD_ADM_UT_STT_LD table for a link between the

1483: -- which was used in the original discontinuation. If this alias_val :
1484: -- 1. if prior to the load calendar instance - then load is never incurred
1485: -- 2. is after the load calendar instance - then load is always incurred.
1486: -- ELSE
1487: -- it checks the IGS_AD_ADM_UT_STT_LD table for a link between the
1488: -- administrative
1489: -- unit status and the load calendar as at the effective date.
1490: -- For ENROLLED or COMPLETED unit attempts - the load is always incurred.
1491: -- For other statuses - load cannot be incurred.