DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on HZ_CONTACT_POINTS

Line 774: FROM HZ_CONTACT_POINTS

770: AND Status = 'A';
771:
772: CURSOR C_Get_Phone (l_party NUMBER) IS
773: SELECT Contact_Point_Id
774: FROM HZ_CONTACT_POINTS
775: WHERE Owner_Table_Id = l_party
776: AND Owner_Table_Name = 'HZ_PARTIES'
777: AND Contact_Point_Type = 'PHONE'
778: AND Status = 'A'