APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTIES

Line 768: FROM HZ_PARTIES

764: IS
765:
766: CURSOR C_Get_Type (l_party NUMBER) IS
767: SELECT Party_Type
768: FROM HZ_PARTIES
769: WHERE Party_Id = l_party
770: AND Status = 'A';
771:
772: CURSOR C_Get_Phone (l_party NUMBER) IS

Line 776: AND Owner_Table_Name = 'HZ_PARTIES'

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'
779: AND Primary_Flag = 'Y';
780:

Line 883: FROM HZ_PARTIES

879: IS
880:
881: CURSOR C_Get_Type (l_party NUMBER) IS
882: SELECT Party_Type
883: FROM HZ_PARTIES
884: WHERE Party_Id = l_party
885: AND Status = 'A';
886:
887: CURSOR C_Use_Exists (l_party NUMBER) IS

Line 1105: FROM HZ_PARTIES

1101: IS
1102:
1103: CURSOR C_Get_Type (l_party NUMBER) IS
1104: SELECT Party_Type
1105: FROM HZ_PARTIES
1106: WHERE Party_Id = l_party
1107: AND Status = 'A';
1108:
1109: CURSOR C_Use_Exists (l_party NUMBER) IS

Line 1332: FROM HZ_PARTIES

1328: IS
1329:
1330: CURSOR C_Get_Type (l_party NUMBER) IS
1331: SELECT Party_Type
1332: FROM HZ_PARTIES
1333: WHERE Party_Id = l_party
1334: AND Status = 'A';
1335:
1336: CURSOR C_Use_Exists (l_party NUMBER) IS