DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on HZ_CONTACT_POINTS

Line 1243: FROM hz_contact_points party_cont,

1239: SELECT ar.meaning PHONE_TYPE,
1240: nvl2(party_cont.phone_country_code, party_cont.phone_country_code || '-',null ) ||
1241: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1242: party_cont.phone_number PHONE_NUMBER
1243: FROM hz_contact_points party_cont,
1244: cs_hz_sr_contact_points sr_cont,
1245: FND_LOOKUP_VALUES ar
1246: WHERE sr_cont.incident_id = v_incident_id
1247: AND sr_cont.contact_point_id = party_cont.contact_point_id

Line 1277: FROM hz_contact_points party_cont,

1273:
1274: --:Contact_Email
1275: CURSOR Get_Contact_Email (v_incident_id NUMBER) IS
1276: SELECT party_cont.email_address EMAIL
1277: FROM hz_contact_points party_cont,
1278: cs_hz_sr_contact_points sr_cont
1279: WHERE sr_cont.incident_id = v_incident_id
1280: AND sr_cont.contact_point_id = party_cont.contact_point_id
1281: AND sr_cont.contact_type <> 'EMPLOYEE'