DBA Data[Home] [Help]

APPS.CSM_PARTY_EVENT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 141: From CS_HZ_SR_CONTACT_POINTS cont,

137: )
138: AND NOT EXISTS
139: (
140: SELECT 1
141: From CS_HZ_SR_CONTACT_POINTS cont,
142: CSM_SR_CONTACTS_ACC src
143: WHERE src.USER_ID = p.USER_ID
144: AND cont.PARTY_ID = p.PARTY_ID
145: AND src.sr_contact_point_id = cont.sr_contact_point_id

Line 323: From CS_HZ_SR_CONTACT_POINTS cont,

319: )
320: AND NOT EXISTS
321: (
322: SELECT 1
323: From CS_HZ_SR_CONTACT_POINTS cont,
324: CSM_SR_CONTACTS_ACC src
325: WHERE src.USER_ID = p.USER_ID
326: AND cont.PARTY_ID = p.PARTY_ID
327: AND src.sr_contact_point_id = cont.sr_contact_point_id