DBA Data[Home] [Help]

APPS.AS_RTTAP_ACCOUNT dependencies on HZ_CONTACT_POINTS

Line 201: FROM hz_contact_points

197:
198: FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
199: CURSOR c1 IS
200: SELECT owner_table_name,owner_table_id
201: FROM hz_contact_points
202: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')
203: AND primary_flag = 'Y'
204: AND contact_point_type ='PHONE'
205: AND status <>'I';

Line 251: FROM hz_contact_points

247:
248: FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
249: CURSOR C1 IS
250: SELECT owner_table_name,owner_table_id
251: FROM hz_contact_points
252: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')
253: AND primary_flag = 'Y'
254: AND contact_point_type ='PHONE'
255: AND status <>'I';