APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_PERS_DISABLTY_V

Line 1275: FROM igs_pe_pers_disablty_v

1271:
1272: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
1273: CURSOR c_dis IS
1274: SELECT disability_type
1275: FROM igs_pe_pers_disablty_v
1276: WHERE person_id = p_person_id
1277: AND ( Start_Date IS NULL OR Start_Date <= p_enrl_end_dt )
1278: AND ( End_Date IS NULL OR End_Date >= p_enrl_start_dt )
1279: ORDER BY Start_Date DESC;

Line 1282: l_disability igs_pe_pers_disablty_v.disability_type%TYPE;

1278: AND ( End_Date IS NULL OR End_Date >= p_enrl_start_dt )
1279: ORDER BY Start_Date DESC;
1280:
1281: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1282: l_disability igs_pe_pers_disablty_v.disability_type%TYPE;
1283: l_hesa_disability igs_he_ex_rn_dat_fd.value%TYPE;
1284:
1285: BEGIN
1286: -- jbaber modified association code, HEFD350