DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SCSR dependencies on IGS_GE_SPL_REQ

Line 274: -- Validate that the IGS_GE_SPL_REQ is not closed

270: p_special_requirement_cd IN VARCHAR2 ,
271: p_message_name OUT NOCOPY VARCHAR2)
272: RETURN BOOLEAN AS
273: BEGIN -- enrp_val_srq_closed
274: -- Validate that the IGS_GE_SPL_REQ is not closed
275: DECLARE
276: CURSOR c_srq IS
277: SELECT 'x'
278: FROM IGS_GE_SPL_REQ srq

Line 278: FROM IGS_GE_SPL_REQ srq

274: -- Validate that the IGS_GE_SPL_REQ is not closed
275: DECLARE
276: CURSOR c_srq IS
277: SELECT 'x'
278: FROM IGS_GE_SPL_REQ srq
279: WHERE srq.special_requirement_cd = p_special_requirement_cd AND
280: srq.closed_ind = 'Y';
281: v_closed_ind VARCHAR2(1) DEFAULT NULL;
282: BEGIN