APPS.IGS_AD_GEN_006 dependencies on IGS_AD_INTAK_TRG_TYP

Line 116: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;

112: BEGIN -- admp_get_itt_amttyp
113: -- Description: This module retrieves the s_amount_type from
114: -- intake_target_type for a given intake_target_type.
115: DECLARE
116: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
117: CURSOR c_itt IS
118: SELECT itt.s_amount_type
119: FROM IGS_AD_INTAK_TRG_TYP itt
120: WHERE itt.intake_target_type = p_intake_target_type;

Line 119: FROM IGS_AD_INTAK_TRG_TYP itt

115: DECLARE
116: v_s_amount_type IGS_AD_INTAK_TRG_TYP.s_amount_type%TYPE;
117: CURSOR c_itt IS
118: SELECT itt.s_amount_type
119: FROM IGS_AD_INTAK_TRG_TYP itt
120: WHERE itt.intake_target_type = p_intake_target_type;
121: BEGIN
122: OPEN c_itt;
123: FETCH c_itt INTO v_s_amount_type;