APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on HZ_CONTACT_POINTS

Line 1140: FROM hz_contact_points hcp,

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

Line 1195: FROM hz_contact_points

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

Line 1205: FROM hz_contact_points

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

Line 1253: FROM hz_contact_points hcp,

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

Line 1288: FROM hz_contact_points hcp,

1284: cshcp.party_id,
1285: to_number(NULL) person_id,
1286: cshcp.contact_type,
1287: cshcp.sr_contact_point_id
1288: FROM hz_contact_points hcp,
1289: cs_hz_sr_contact_points cshcp
1290: WHERE cshcp.INCIDENT_ID = l_request_id
1291: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1292: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1320: FROM hz_contact_points hcp,

1316: cshcp.party_id,
1317: to_number(NULL) person_id,
1318: cshcp.contact_type,
1319: cshcp.sr_contact_point_id
1320: FROM hz_contact_points hcp,
1321: cs_hz_sr_contact_points cshcp
1322: WHERE
1323: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1324: AND hcp.CONTACT_POINT_ID = l_contact_point_id

Line 1353: FROM hz_contact_points hcp,

1349: cshcp.contact_type,
1350: cshcp.sr_contact_point_id,
1351: cpr.name,
1352: cpr.party_role_code
1353: FROM hz_contact_points hcp,
1354: cs_hz_sr_contact_points cshcp,
1355: cs_party_roles_tl cpr
1356: WHERE
1357: hcp.CONTACT_POINT_TYPE = 'EMAIL'