APPS.ASO_SALES_CREDIT_PVT dependencies on HZ_CONTACT_POINTS
Line 452: FROM HZ_CONTACT_POINTS
448: AND A.party_site_id = l_party_site;
449:
450: CURSOR C_Get_Cust_Cont_Info (l_party_id NUMBER) IS
451: SELECT Phone_Area_Code 452: FROM HZ_CONTACT_POINTS 453: WHERE Owner_Table_Id = l_party_id
454: AND Owner_Table_Name = 'HZ_PARTIES'
455: AND Contact_Point_Type = 'PHONE'
456: AND Status = 'A'