APPS.IGS_PS_VAL_DI dependencies on IGS_PS_GOVT_DSCP

Line 10: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;

6: FUNCTION crsp_val_di_govt_dg(
7: p_govt_discipline_group_cd IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;
11: CURSOR c_govt_discipline IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_DSCP
14: WHERE govt_discipline_group_cd = p_govt_discipline_group_cd;

Line 13: FROM IGS_PS_GOVT_DSCP

9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;
11: CURSOR c_govt_discipline IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_DSCP
14: WHERE govt_discipline_group_cd = p_govt_discipline_group_cd;
15: BEGIN
16: OPEN c_govt_discipline;
17: FETCH c_govt_discipline INTO v_closed_ind;