DBA Data[Home] [Help]

APPS.IGS_AD_VAL_AALP dependencies on IGS_CO_LTR_PARM_TYPE

Line 16: FROM IGS_CO_LTR_PARM_TYPE

12: DECLARE
13: v_closed_ind IGS_CO_LTR_PHR.closed_ind%TYPE DEFAULT 'N';
14: CURSOR c_lpt IS
15: SELECT closed_ind
16: FROM IGS_CO_LTR_PARM_TYPE
17: WHERE letter_parameter_type = p_letter_parameter_type;
18: BEGIN
19: p_message_name := null;
20: OPEN c_lpt;

Line 48: FROM IGS_CO_LTR_PARM_TYPE

44: DECLARE
45: v_check CHAR;
46: CURSOR c_lpt IS
47: SELECT 'x'
48: FROM IGS_CO_LTR_PARM_TYPE
49: WHERE letter_parameter_type = p_letter_parameter_type AND
50: s_letter_parameter_type = 'PHRASE' AND
51: closed_ind = 'N';
52: BEGIN