APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_OTM_LOC_CONTACTS_GTMP

Line 330: FROM WSH_OTM_LOC_CONTACTS_GTMP

326: p_location_id IN NUMBER,
327: p_corporation_id IN NUMBER
328: ) is
329: SELECT 'X'
330: FROM WSH_OTM_LOC_CONTACTS_GTMP
331: WHERE CONTACT_ID = p_contact_id
332: AND LOCATION_ID = p_location_id
333: AND CORPORATION_ID = p_corporation_id
334: AND LOCATION_TYPE = 'CUST_LOC';

Line 577: insert into WSH_OTM_LOC_CONTACTS_GTMP

573: WSH_DEBUG_SV.log(l_module_name,'contact exists',l_contact_exists);
574: END IF;
575: IF (l_contact_exists IS NULL) THEN
576: --{
577: insert into WSH_OTM_LOC_CONTACTS_GTMP
578: (contact_id, location_id, corporation_id, location_type)
579: values(del_contact_rec.contact_id, l_st_loc_id,del_contact_rec.customer_id, 'CUST_LOC');
580: --}
581: END IF;

Line 1490: WSH_OTM_LOC_CONTACTS_GTMP WLCT

1486: HZ_RELATIONSHIPS HREL,
1487: HZ_ORG_CONTACTS HOC,
1488: HZ_CONTACT_POINTS PHONE_CONTACT,
1489: HZ_PARTIES PER_CONTACT,
1490: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1491: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1492: AND HCAR.ROLE_TYPE = 'CONTACT'
1493: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1494: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'