DBA Data[Home] [Help]

APPS.IGS_AD_VAL_AAL dependencies on IGS_CO_TYPE

Line 152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;

148: p_message_name OUT NOCOPY VARCHAR2 )
149: RETURN BOOLEAN IS
150: BEGIN
151: DECLARE
152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort

Line 154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS

150: BEGIN
151: DECLARE
152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort
157: WHERE cort.correspondence_type = cp_correspondence_type;
158: BEGIN

Line 156: FROM IGS_CO_TYPE cort

152: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
153: CURSOR c_cort(
154: cp_correspondence_type IGS_CO_TYPE.correspondence_type%TYPE) IS
155: SELECT cort.closed_ind
156: FROM IGS_CO_TYPE cort
157: WHERE cort.correspondence_type = cp_correspondence_type;
158: BEGIN
159: -- Validate if the correspondence type is closed
160: p_message_name := null;