APPS.IGS_PE_CITIZENSHIPS_PKG dependencies on HZ_CITIZENSHIP

Line 31: FROM hz_citizenship

27: WHERE person_id = cp_person_id ;
28:
29: CURSOR validate_dt_overlap(cp_party_id NUMBER, cp_start_date DATE, cp_end_date DATE , cp_citzn_id NUMBER , cp_country_cd VARCHAR2) IS
30: SELECT 'X'
31: FROM hz_citizenship
32: WHERE party_id = cp_party_id
33: AND cp_country_cd = country_code
34: AND (cp_citzn_id <> citizenship_id OR cp_citzn_id IS NULL)
35: AND (cp_start_date between date_recognized AND NVL(end_date,l_default_date)