DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on HZ_CONTACT_POINTS

Line 781: FROM HZ_CONTACT_POINTS

777: AND Status = 'A';
778:
779: CURSOR C_Get_Phone (l_party NUMBER) IS
780: SELECT Contact_Point_Id
781: FROM HZ_CONTACT_POINTS
782: WHERE Owner_Table_Id = l_party
783: AND Owner_Table_Name = 'HZ_PARTIES'
784: AND Contact_Point_Type = 'PHONE'
785: AND Status = 'A'