DBA Data[Home] [Help]

APPS.IGS_PS_VAL_UCL dependencies on IGS_AS_UNIT_MODE

Line 10: v_closed_ind IGS_AS_UNIT_MODE.closed_ind%TYPE;

6: FUNCTION crsp_val_ucl_um(
7: p_unit_mode IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_AS_UNIT_MODE.closed_ind%TYPE;
11: CURSOR c_unit_mode_closed_ind IS
12: SELECT closed_ind
13: FROM IGS_AS_UNIT_MODE
14: WHERE unit_mode = p_unit_mode AND

Line 13: FROM IGS_AS_UNIT_MODE

9: RETURN BOOLEAN AS
10: v_closed_ind IGS_AS_UNIT_MODE.closed_ind%TYPE;
11: CURSOR c_unit_mode_closed_ind IS
12: SELECT closed_ind
13: FROM IGS_AS_UNIT_MODE
14: WHERE unit_mode = p_unit_mode AND
15: closed_ind = 'Y';
16: BEGIN
17: OPEN c_unit_mode_closed_ind;