APPS.IGS_EN_VAL_PDI dependencies on IGS_PE_PERS_DISABLTY

Line 15: FROM IGS_PE_PERS_DISABLTY pdi,

11: DECLARE
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

Line 22: FROM IGS_PE_PERS_DISABLTY pdi1,

18: dit.disability_type = pdi.disability_type AND
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