APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_PERS_DISABLTY

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

Line 7429: FROM igs_he_code_map_val a, igs_pe_pers_disablty b

7425: l_map1 igs_he_code_map_val.map1%TYPE;
7426:
7427: CURSOR c_hesa_dis_types IS
7428: SELECT map1
7429: FROM igs_he_code_map_val a, igs_pe_pers_disablty b
7430: WHERE a.map2 = b.disability_type
7431: AND a.association_code = 'OSS_HESA_LEARNDIF_ASSOC'
7432: AND NOT NVL(b.start_date, p_enrl_end_dt) > p_enrl_end_dt
7433: AND NOT NVL(b.end_date, p_enrl_start_dt) < p_enrl_start_dt