APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTIES

Line 775: FROM HZ_PARTIES

771: IS
772:
773: CURSOR C_Get_Type (l_party NUMBER) IS
774: SELECT Party_Type
775: FROM HZ_PARTIES
776: WHERE Party_Id = l_party
777: AND Status = 'A';
778:
779: CURSOR C_Get_Phone (l_party NUMBER) IS

Line 783: AND Owner_Table_Name = 'HZ_PARTIES'

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'
786: AND Primary_Flag = 'Y';
787:

Line 890: FROM HZ_PARTIES

886: IS
887:
888: CURSOR C_Get_Type (l_party NUMBER) IS
889: SELECT Party_Type
890: FROM HZ_PARTIES
891: WHERE Party_Id = l_party
892: AND Status = 'A';
893:
894: CURSOR C_Use_Exists (l_party NUMBER) IS

Line 1112: FROM HZ_PARTIES

1108: IS
1109:
1110: CURSOR C_Get_Type (l_party NUMBER) IS
1111: SELECT Party_Type
1112: FROM HZ_PARTIES
1113: WHERE Party_Id = l_party
1114: AND Status = 'A';
1115:
1116: CURSOR C_Use_Exists (l_party NUMBER) IS

Line 1343: FROM HZ_PARTIES

1339: IS
1340:
1341: CURSOR C_Get_Type (l_party NUMBER) IS
1342: SELECT Party_Type
1343: FROM HZ_PARTIES
1344: WHERE Party_Id = l_party
1345: AND Status = 'A';
1346:
1347: CURSOR C_Use_Exists (l_party NUMBER) IS