APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTY_SITES

Line 889: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

885: AND Status = 'A';
886:
887: CURSOR C_Use_Exists (l_party NUMBER) IS
888: SELECT A.Party_Site_Id
889: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
890: WHERE A.Party_Id = l_party
891: AND A.Party_Site_Id = B.Party_Site_Id
892: AND B.Site_Use_Type = 'SOLD_TO'
893: AND B.Primary_Per_Type = 'Y'

Line 899: FROM HZ_PARTY_SITES

895: AND B.Status = 'A';
896:
897: CURSOR C_Get_PrAddr (l_party NUMBER) IS
898: SELECT Party_Site_Id
899: FROM HZ_PARTY_SITES
900: WHERE Party_Id = l_party
901: AND Identifying_Address_Flag = 'Y'
902: AND Status = 'A';
903:

Line 1111: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

1107: AND Status = 'A';
1108:
1109: CURSOR C_Use_Exists (l_party NUMBER) IS
1110: SELECT A.Party_Site_Id
1111: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
1112: WHERE A.Party_Id = l_party
1113: AND A.Party_Site_Id = B.Party_Site_Id
1114: AND B.Site_Use_Type = 'BILL_TO'
1115: AND B.Primary_Per_Type = 'Y'

Line 1121: FROM HZ_PARTY_SITES

1117: AND B.Status = 'A';
1118:
1119: CURSOR C_Get_PrAddr (l_party NUMBER) IS
1120: SELECT Party_Site_Id
1121: FROM HZ_PARTY_SITES
1122: WHERE Party_Id = l_party
1123: AND Identifying_Address_Flag = 'Y'
1124: AND Status = 'A';
1125:

Line 1338: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

1334: AND Status = 'A';
1335:
1336: CURSOR C_Use_Exists (l_party NUMBER) IS
1337: SELECT A.Party_Site_Id
1338: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
1339: WHERE A.Party_Id = l_party
1340: AND A.Party_Site_Id = B.Party_Site_Id
1341: AND B.Site_Use_Type = 'SHIP_TO'
1342: AND B.Primary_Per_Type = 'Y'

Line 1348: FROM HZ_PARTY_SITES

1344: AND B.Status = 'A';
1345:
1346: CURSOR C_Get_PrAddr (l_party NUMBER) IS
1347: SELECT Party_Site_Id
1348: FROM HZ_PARTY_SITES
1349: WHERE Party_Id = l_party
1350: AND Identifying_Address_Flag = 'Y'
1351: AND Status = 'A';
1352: