APPS.IGS_AS_VAL_UAPI dependencies on IGS_AS_UNITASS_ITEM

Line 25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;

21: cst_null CONSTANT VARCHAR2(4) := 'NULL';
22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;
23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;
27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;
28: CURSOR c_uap IS
29: SELECT uap.location_cd,

Line 26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;

22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;
23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;
27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;
28: CURSOR c_uap IS
29: SELECT uap.location_cd,
30: uap.unit_class,

Line 27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;

23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;
27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;
28: CURSOR c_uap IS
29: SELECT uap.location_cd,
30: uap.unit_class,
31: uap.unit_mode

Line 38: FROM IGS_AS_UNITASS_ITEM uai

34: CURSOR c_uai IS
35: SELECT uai.location_cd,
36: uai.unit_class,
37: uai.unit_mode
38: FROM IGS_AS_UNITASS_ITEM uai
39: WHERE uai.unit_cd = p_unit_cd AND
40: uai.version_number = p_version_number AND
41: uai.cal_type = p_cal_type AND
42: uai.ci_sequence_number = p_ci_sequence_number AND