APPS.ARI_UTILITIES dependencies on HZ_CONTACT_POINTS

Line 1078: HZ_CONTACT_POINTS CONT_POINT

1074: SELECT phone_id FROM
1075: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1076: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1077: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1078: HZ_CONTACT_POINTS CONT_POINT
1079: WHERE
1080: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1081: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1082: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 1121: FROM HZ_CONTACT_POINTS CONT_POINT

1117: CONT_POINT.TELEX_NUMBER,
1118: CONT_POINT.PHONE_NUMBER)||'-'||
1119: CONT_POINT.PHONE_EXTENSION, '-'), '-')
1120: INTO l_contact_phone
1121: FROM HZ_CONTACT_POINTS CONT_POINT
1122: WHERE CONT_POINT.CONTACT_POINT_ID = l_phone_id;
1123: --
1124: END IF;
1125:

Line 1165: HZ_CONTACT_POINTS CONT_POINT

1161: SELECT phone_id FROM
1162: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1163: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1164: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1165: HZ_CONTACT_POINTS CONT_POINT
1166: WHERE
1167: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1168: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1169: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 1204: FROM HZ_CONTACT_POINTS CONT_POINT

1200: CONT_POINT.TELEX_NUMBER,
1201: CONT_POINT.PHONE_NUMBER)||'-'||
1202: CONT_POINT.PHONE_EXTENSION, '-'), '-')
1203: INTO l_contact_phone
1204: FROM HZ_CONTACT_POINTS CONT_POINT
1205: WHERE CONT_POINT.CONTACT_POINT_ID = l_phone_id;
1206: --
1207: END IF;
1208:

Line 2238: l_email_address hz_contact_points.email_Address%TYPE;

2234:
2235: l_adhoc_user_name VARCHAR2(200);
2236: l_adhoc_user_display_name VARCHAR2(200);
2237:
2238: l_email_address hz_contact_points.email_Address%TYPE;
2239: l_user_email_addr_list email_addr_type;
2240: l_adhoc_users_list varchar2 (32760) := null;
2241: l_contact_id NUMBER := NULL;
2242: i PLS_INTEGER := 1 ;

Line 2274: hz_contact_points cont_point

2270:
2271: CURSOR email_addr_cur (l_contact_id IN NUMBER DEFAULT NULL) IS
2272: SELECT cont_point.email_Address
2273: FROM hz_cust_account_roles acct_role,
2274: hz_contact_points cont_point
2275: WHERE acct_role.cust_account_role_id =l_contact_id
2276: AND acct_role.party_id = cont_point.owner_table_id
2277: AND cont_point.owner_table_name = 'HZ_PARTIES'
2278: AND cont_point.status = 'A'