DBA Data[Home] [Help]

APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_CONTACT_POINTS

Line 1102: FROM hz_contact_points C,

1098: -- cursor definitions
1099: CURSOR CUR_CONTACTS(p_contact_id NUMBER) IS
1100: SELECT acct_role.party_id party_id, C.contact_point_id,
1101: C.contact_point_type,C.primary_flag
1102: FROM hz_contact_points C,
1103: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1104: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1105: and C.owner_table_name(+)='HZ_PARTIES'
1106: and C.contact_point_type(+)='PHONE'