APPS.IGS_EN_GEN_003 dependencies on IGS_EN_DCNT_REASONCD

Line 36: v_dis_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;

32: p_description OUT NOCOPY VARCHAR2 )
33: RETURN VARCHAR2 AS
34: BEGIN
35: DECLARE
36: v_dis_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
37: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
38:
39: CURSOR c_drcd IS
40: SELECT discontinuation_reason_cd,

Line 37: v_description IGS_EN_DCNT_REASONCD.description%TYPE;

33: RETURN VARCHAR2 AS
34: BEGIN
35: DECLARE
36: v_dis_reason_cd IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
37: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
38:
39: CURSOR c_drcd IS
40: SELECT discontinuation_reason_cd,
41: description

Line 42: FROM IGS_EN_DCNT_REASONCD

38:
39: CURSOR c_drcd IS
40: SELECT discontinuation_reason_cd,
41: description
42: FROM IGS_EN_DCNT_REASONCD
43: WHERE dflt_ind = 'Y' AND
44: closed_ind = 'N';
45: BEGIN
46: -- This module retrieves the default discontinuation