APPS.ARI_UTILITIES dependencies on HZ_CONTACT_POINTS

Line 1035: HZ_CONTACT_POINTS CONT_POINT

1031: SELECT phone_id FROM
1032: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1033: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1034: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1035: HZ_CONTACT_POINTS CONT_POINT
1036: WHERE
1037: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1038: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1039: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 1078: FROM HZ_CONTACT_POINTS CONT_POINT

1074: CONT_POINT.TELEX_NUMBER,
1075: CONT_POINT.PHONE_NUMBER)||'-'||
1076: CONT_POINT.PHONE_EXTENSION, '-'), '-')
1077: INTO l_contact_phone
1078: FROM HZ_CONTACT_POINTS CONT_POINT
1079: WHERE CONT_POINT.CONTACT_POINT_ID = l_phone_id;
1080: --
1081: END IF;
1082:

Line 1122: HZ_CONTACT_POINTS CONT_POINT

1118: SELECT phone_id FROM
1119: ( SELECT CONT_POINT.CONTACT_POINT_ID phone_id,
1120: row_number() OVER ( order by CONT_POINT.last_update_date desc) last_update_record
1121: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1122: HZ_CONTACT_POINTS CONT_POINT
1123: WHERE
1124: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1125: AND ACCT_ROLE.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
1126: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 1161: FROM HZ_CONTACT_POINTS CONT_POINT

1157: CONT_POINT.TELEX_NUMBER,
1158: CONT_POINT.PHONE_NUMBER)||'-'||
1159: CONT_POINT.PHONE_EXTENSION, '-'), '-')
1160: INTO l_contact_phone
1161: FROM HZ_CONTACT_POINTS CONT_POINT
1162: WHERE CONT_POINT.CONTACT_POINT_ID = l_phone_id;
1163: --
1164: END IF;
1165:

Line 1837: hz_contact_points cont_point

1833:
1834: CURSOR email_addr_cur (l_contact_id IN NUMBER DEFAULT NULL) IS
1835: SELECT cont_point.email_Address
1836: FROM hz_cust_account_roles acct_role,
1837: hz_contact_points cont_point
1838: WHERE acct_role.cust_account_role_id =l_contact_id
1839: AND acct_role.party_id = cont_point.owner_table_id
1840: AND cont_point.owner_table_name = 'HZ_PARTIES'
1841: AND cont_point.status = 'A'