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_AS_VAL_UAPI dependencies on IGS_AS_UNT_PATRN_ITM

Line 17: -- IGS_AS_UNT_PATRN_ITM is valid for the IGS_PS_UNIT offering options that the

13: RETURN BOOLEAN IS
14: gv_other_detail VARCHAR2(255);
15: BEGIN -- assp_val_uapi_uoo
16: -- This module validate that the IGS_AS_ASSESSMNT_ITM being assigned to the
17: -- IGS_AS_UNT_PATRN_ITM is valid for the IGS_PS_UNIT offering options that the
18: -- IGS_AS_UNTAS_PATTERN applies too. That is, the IGS_AD_LOCATION, mode and
19: -- class must be identical.
20: DECLARE
21: cst_null CONSTANT VARCHAR2(4) := 'NULL';

Line 105: FROM IGS_AS_UNT_PATRN_ITM uapi

101: DECLARE
102: v_total_apportionment_percent NUMBER;
103: CURSOR c_uapi IS
104: SELECT NVL(SUM(uapi.apportionment_percentage), 0)
105: FROM IGS_AS_UNT_PATRN_ITM uapi
106: WHERE uapi.unit_cd = p_unit_cd AND
107: uapi.version_number = p_version_number AND
108: uapi.cal_type = p_cal_type AND
109: uapi.ci_sequence_number = p_ci_sequence_number AND