APPS.IGS_EN_VAL_PDI dependencies on IGS_AD_DISBL_TYPE

Line 16: IGS_AD_DISBL_TYPE dit

12: cst_none CONSTANT VARCHAR2(10) := 'NONE';
13: CURSOR c_pdi IS
14: SELECT 'x'
15: FROM IGS_PE_PERS_DISABLTY pdi,
16: IGS_AD_DISBL_TYPE dit
17: WHERE pdi.person_id = p_person_id AND
18: dit.disability_type = pdi.disability_type AND
19: dit.govt_disability_type = cst_NONE AND
20: EXISTS (

Line 23: IGS_AD_DISBL_TYPE dit1

19: dit.govt_disability_type = cst_NONE AND
20: EXISTS (
21: SELECT 'x'
22: FROM IGS_PE_PERS_DISABLTY pdi1,
23: IGS_AD_DISBL_TYPE dit1
24: WHERE pdi1.person_id = p_person_id AND
25: dit1.disability_type = pdi1.disability_type AND
26: dit1.govt_disability_type <> cst_NONE
27: );

Line 75: FROM IGS_AD_DISBL_TYPE dit

71: cst_none CONSTANT VARCHAR2(10) := 'NONE';
72: v_govt_disability_type VARCHAR2(30);
73: CURSOR c_dit IS
74: SELECT govt_disability_type
75: FROM IGS_AD_DISBL_TYPE dit
76: WHERE dit.disability_type = p_disability_type;
77: BEGIN
78: p_message_name := NULL;
79: IF (p_contact_ind = 'N') THEN

Line 121: FROM IGS_AD_DISBL_TYPE

117:
118: v_closed_ind VARCHAR2(1);
119: CURSOR c_disability_type IS
120: SELECT closed_ind
121: FROM IGS_AD_DISBL_TYPE
122: WHERE disability_type = p_disability_type;
123: BEGIN
124: -- Check if the disability_type is closed
125: p_message_name := NULL;