APPS.IGS_ST_VAL_GDHC dependencies on IGS_FI_GV_DSP_HEC_CN

Line 16: FROM IGS_FI_GV_DSP_HEC_CN gdhc

12: DECLARE
13: CURSOR c_gdhc_rec IS
14: SELECT gdhc.start_dt,
15: gdhc.end_dt
16: FROM IGS_FI_GV_DSP_HEC_CN gdhc
17: WHERE gdhc.govt_discipline_group_cd = p_govt_discipline_group_cd AND
18: gdhc.start_dt <> p_start_dt;
19: BEGIN
20: -- this module validates the IGS_FI_GV_DSP_HEC_CN table

Line 20: -- this module validates the IGS_FI_GV_DSP_HEC_CN table

16: FROM IGS_FI_GV_DSP_HEC_CN gdhc
17: WHERE gdhc.govt_discipline_group_cd = p_govt_discipline_group_cd AND
18: gdhc.start_dt <> p_start_dt;
19: BEGIN
20: -- this module validates the IGS_FI_GV_DSP_HEC_CN table
21: -- to ensure that for records with the same
22: -- govt_discipline_group_cd and govt_hecs_cntrbtn_band that
23: -- the data ranges don't overlap
24: --- Set the default message number

Line 77: -- this module validates the IGS_FI_GV_DSP_HEC_CN table

73: p_start_dt IN DATE ,
74: p_message_name OUT NOCOPY VARCHAR2 )
75: RETURN BOOLEAN AS
76: BEGIN
77: -- this module validates the IGS_FI_GV_DSP_HEC_CN table
78: -- to ensure that for records with the same
79: -- govt_discipline_group_cd and govt_hecs_cntrbtn_band that
80: -- only one record has a NULL end_dt
81: DECLARE

Line 85: FROM IGS_FI_GV_DSP_HEC_CN gdhc

81: DECLARE
82: v_start_dt DATE;
83: CURSOR c_gdhc_rec IS
84: SELECT gdhc.start_dt
85: FROM IGS_FI_GV_DSP_HEC_CN gdhc
86: WHERE gdhc.govt_discipline_group_cd = p_govt_discipline_group_cd AND
87: gdhc.start_dt <> p_start_dt AND
88: gdhc.end_dt IS NULL;
89: BEGIN

Line 127: --- Validate the govt_discipline_group_cd in the IGS_FI_GV_DSP_HEC_CN is

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
130: --- discipline group is closed.
131: --- Set the default message number

Line 162: -- this module validates the IGS_FI_GV_DSP_HEC_CN table

158: p_end_dt IN DATE ,
159: p_message_name OUT NOCOPY VARCHAR2 )
160: RETURN BOOLEAN AS
161: BEGIN
162: -- this module validates the IGS_FI_GV_DSP_HEC_CN table
163: -- to ensure that if the end_dt is not null, it is greater
164: -- than or equal to the start_dt
165: DECLARE
166: BEGIN