DBA Data[Home] [Help]

APPS.IGS_ST_VAL_GDHC dependencies on IGS_PS_GOVT_DSCP

Line 123: FROM IGS_PS_GOVT_DSCP gd

119: BEGIN
120: DECLARE
121: CURSOR c_gd IS
122: SELECT gd.closed_ind
123: FROM IGS_PS_GOVT_DSCP gd
124: WHERE gd.govt_discipline_group_cd = p_govt_discipline_group_cd;
125: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;
126: BEGIN
127: --- Validate the govt_discipline_group_cd in the IGS_FI_GV_DSP_HEC_CN is

Line 125: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;

121: CURSOR c_gd IS
122: SELECT gd.closed_ind
123: FROM IGS_PS_GOVT_DSCP gd
124: WHERE gd.govt_discipline_group_cd = p_govt_discipline_group_cd;
125: v_closed_ind IGS_PS_GOVT_DSCP.closed_ind%TYPE;
126: BEGIN
127: --- Validate the govt_discipline_group_cd in the IGS_FI_GV_DSP_HEC_CN is
128: --- not closed.
129: --- Set the message number and return false to indicate that the government