APPS.IGS_AD_SS_GEN_001 dependencies on HZ_CONTACT_POINTS

Line 3606: FROM hz_contact_points

3602:
3603: -- Phone - PHONE
3604: CURSOR c_phone(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS
3605: SELECT 'x'
3606: FROM hz_contact_points
3607: WHERE CONTACT_POINT_TYPE = 'PHONE'
3608: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3609: AND STATUS = 'A'
3610: AND PHONE_LINE_TYPE IN

Line 3621: FROM hz_contact_points

3617:
3618: -- Email- EMAIL
3619: CURSOR c_email(cp_person_id igs_ad_appl.person_id%TYPE) IS
3620: SELECT 'x'
3621: FROM hz_contact_points
3622: WHERE CONTACT_POINT_TYPE = 'EMAIL'
3623: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3624: AND STATUS = 'A'
3625: AND OWNER_TABLE_ID = cp_person_id;