APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_PERS_DISABLTY_V

Line 2464: CURSOR cur_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE,

2460: WHERE association_code = cp_assoc
2461: AND map1 = cp_map1;
2462: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2463:
2464: CURSOR cur_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE,
2465: cp_disability_type IGS_PE_PERS_DISABLTY_V.disability_type%TYPE) IS
2466: SELECT start_date, end_date
2467: FROM IGS_PE_PERS_DISABLTY
2468: WHERE person_id = cp_person_id

Line 2465: cp_disability_type IGS_PE_PERS_DISABLTY_V.disability_type%TYPE) IS

2461: AND map1 = cp_map1;
2462: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2463:
2464: CURSOR cur_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE,
2465: cp_disability_type IGS_PE_PERS_DISABLTY_V.disability_type%TYPE) IS
2466: SELECT start_date, end_date
2467: FROM IGS_PE_PERS_DISABLTY
2468: WHERE person_id = cp_person_id
2469: AND disability_type = cp_disability_type

Line 2474: CURSOR cur_other_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE) IS

2470: ORDER BY start_date DESC;
2471: cur_disablty_dtls_rec cur_disablty_dtls%ROWTYPE;
2472:
2473: -- Fetch the past disability records with end date as NULL
2474: CURSOR cur_other_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE) IS
2475: SELECT disability_type,start_date
2476: FROM IGS_PE_PERS_DISABLTY
2477: WHERE person_id = cp_person_id
2478: AND TRUNC(start_date) <= TRUNC(SYSDATE)