APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on HZ_CONTACT_POINTS

Line 1141: FROM hz_contact_points hcp,

1137: cshcp.party_id,
1138: to_number(NULL) person_id,
1139: cshcp.contact_type,
1140: cshcp.sr_contact_point_id
1141: FROM hz_contact_points hcp,
1142: cs_hz_sr_contact_points cshcp
1143: WHERE cshcp.INCIDENT_ID = l_request_id
1144: AND cshcp.PRIMARY_FLAG = 'Y'
1145: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 1198: FROM hz_contact_points

1194:
1195: CURSOR get_primary_email_info_HZ(p_contact_point_id IN NUMBER,
1196: p_party_id IN NUMBER) IS
1197: SELECT email_address
1198: FROM hz_contact_points
1199: WHERE contact_point_id = p_contact_point_id
1200: AND contact_point_type = 'EMAIL'
1201: AND owner_table_name = 'HZ_PARTIES'
1202: AND owner_table_id = p_party_id ;

Line 1208: FROM hz_contact_points

1204: -- Get any customer email address starting with the primary email address.
1205:
1206: CURSOR get_any_cust_email_address(p_party_id IN NUMBER) IS
1207: SELECT email_address
1208: FROM hz_contact_points
1209: WHERE contact_point_type = 'EMAIL'
1210: AND owner_table_name = 'HZ_PARTIES'
1211: AND owner_table_id = p_party_id
1212: ORDER BY Primary_flag DESC;

Line 1256: FROM hz_contact_points hcp,

1252: cshcp.party_id,
1253: to_number(NULL) person_id,
1254: cshcp.contact_type,
1255: cshcp.sr_contact_point_id
1256: FROM hz_contact_points hcp,
1257: cs_hz_sr_contact_points cshcp
1258: WHERE cshcp.INCIDENT_ID = l_request_id
1259: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1260: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1292: FROM hz_contact_points hcp,

1288: cshcp.party_id,
1289: to_number(NULL) person_id,
1290: cshcp.contact_type,
1291: cshcp.sr_contact_point_id
1292: FROM hz_contact_points hcp,
1293: cs_hz_sr_contact_points cshcp
1294: WHERE cshcp.INCIDENT_ID = l_request_id
1295: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1296: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1324: FROM hz_contact_points hcp,

1320: cshcp.party_id,
1321: to_number(NULL) person_id,
1322: cshcp.contact_type,
1323: cshcp.sr_contact_point_id
1324: FROM hz_contact_points hcp,
1325: cs_hz_sr_contact_points cshcp
1326: WHERE
1327: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1328: AND hcp.CONTACT_POINT_ID = l_contact_point_id

Line 1357: FROM hz_contact_points hcp,

1353: cshcp.contact_type,
1354: cshcp.sr_contact_point_id,
1355: cpr.name,
1356: cpr.party_role_code
1357: FROM hz_contact_points hcp,
1358: cs_hz_sr_contact_points cshcp,
1359: cs_party_roles_tl cpr
1360: WHERE
1361: hcp.CONTACT_POINT_TYPE = 'EMAIL'