APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_CITIZENSHIP_V

Line 1121: FROM igs_pe_citizenship_v a,

1117:
1118: -- smaddali modified this cursor to get replace system date with HESA submission end date, bug#3235753
1119: CURSOR c_ntnl (p_hesa_code VARCHAR2) IS
1120: SELECT b.map3
1121: FROM igs_pe_citizenship_v a,
1122: igs_he_code_map_val b
1123: WHERE a.party_id = p_person_id
1124: AND Nvl(End_Date, p_enrl_start_dt) >= p_enrl_start_dt
1125: AND b.map2 = a.country_code