APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTY_SITE_USES

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 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 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'