APPS.IGS_AD_IMP_011 dependencies on IGS_AD_DISBL_TYPE

Line 1270: CURSOR check_none_disablity_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,

1266: NVL(sn.contact_name,'~') = NVL(cp_contact_name,'~') AND
1267: NVL(TRUNC(sn.contact_date),l_default_date) = NVL(TRUNC(cp_contact_date),l_default_date);
1268:
1269:
1270: CURSOR check_none_disablity_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1271: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE) IS
1272: SELECT 'X'
1273: FROM igs_ad_disbl_type
1274: WHERE disability_type = cp_disability_type AND

Line 1271: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE) IS

1267: NVL(TRUNC(sn.contact_date),l_default_date) = NVL(TRUNC(cp_contact_date),l_default_date);
1268:
1269:
1270: CURSOR check_none_disablity_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1271: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE) IS
1272: SELECT 'X'
1273: FROM igs_ad_disbl_type
1274: WHERE disability_type = cp_disability_type AND
1275: govt_disability_type = cp_govt_disability_type;

Line 1273: FROM igs_ad_disbl_type

1269:
1270: CURSOR check_none_disablity_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1271: cp_govt_disability_type igs_ad_disbl_type.govt_disability_type%TYPE) IS
1272: SELECT 'X'
1273: FROM igs_ad_disbl_type
1274: WHERE disability_type = cp_disability_type AND
1275: govt_disability_type = cp_govt_disability_type;
1276:
1277: disability_rec disability_cur%ROWTYPE;

Line 1305: CURSOR validate_disablty_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,

1301: || Validation done to check if the disability type is None or not.
1302: || npalanis 23-JUL-2002 Bug - 2421897
1303: || Error codes E008 changed to valid ones
1304: */
1305: CURSOR validate_disablty_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1306: cp_closed_ind igs_ad_disbl_type.closed_ind%TYPE) IS
1307: SELECT 'X'
1308: FROM igs_ad_disbl_type
1309: WHERE disability_type = cp_disability_type AND

Line 1306: cp_closed_ind igs_ad_disbl_type.closed_ind%TYPE) IS

1302: || npalanis 23-JUL-2002 Bug - 2421897
1303: || Error codes E008 changed to valid ones
1304: */
1305: CURSOR validate_disablty_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1306: cp_closed_ind igs_ad_disbl_type.closed_ind%TYPE) IS
1307: SELECT 'X'
1308: FROM igs_ad_disbl_type
1309: WHERE disability_type = cp_disability_type AND
1310: closed_ind = cp_closed_ind;

Line 1308: FROM igs_ad_disbl_type

1304: */
1305: CURSOR validate_disablty_cur(cp_disability_type igs_ad_disbl_type.disability_type%TYPE,
1306: cp_closed_ind igs_ad_disbl_type.closed_ind%TYPE) IS
1307: SELECT 'X'
1308: FROM igs_ad_disbl_type
1309: WHERE disability_type = cp_disability_type AND
1310: closed_ind = cp_closed_ind;
1311:
1312: CURSOR validate_interviewer_cur(cp_interviewer_id igs_pe_person_base_v.person_id%TYPE) IS