APPS.FTE_TENDER_WF dependencies on HZ_ORG_CONTACTS

Line 460: hz_org_contacts cont, hz_contact_points points,

456: CURSOR get_notif_type_c (l_trip_id NUMBER) IS
457: SELECT car_sites.tender_transmission_method notif_type,
458: car_sites.auto_accept_load_tender auto_accept_flag,car_sites.carrier_site_id
459: FROM hz_parties party, hz_relationships rel, hz_party_sites sites,
460: hz_org_contacts cont, hz_contact_points points,
461: wsh_carrier_sites car_sites, wsh_trips trips
462: WHERE rel.object_id = party.party_id
463: AND rel.subject_type = 'ORGANIZATION'
464: AND rel.subject_Table_name = 'HZ_PARTIES'