APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTY_SITE_USES

Line 896: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

892: AND Status = 'A';
893:
894: CURSOR C_Use_Exists (l_party NUMBER) IS
895: SELECT A.Party_Site_Id
896: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
897: WHERE A.Party_Id = l_party
898: AND A.Party_Site_Id = B.Party_Site_Id
899: AND B.Site_Use_Type = 'SOLD_TO'
900: AND B.Primary_Per_Type = 'Y'

Line 1118: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

1114: AND Status = 'A';
1115:
1116: CURSOR C_Use_Exists (l_party NUMBER) IS
1117: SELECT A.Party_Site_Id
1118: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
1119: WHERE A.Party_Id = l_party
1120: AND A.Party_Site_Id = B.Party_Site_Id
1121: AND B.Site_Use_Type = 'BILL_TO'
1122: AND B.Primary_Per_Type = 'Y'

Line 1349: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B

1345: AND Status = 'A';
1346:
1347: CURSOR C_Use_Exists (l_party NUMBER) IS
1348: SELECT A.Party_Site_Id
1349: FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
1350: WHERE A.Party_Id = l_party
1351: AND A.Party_Site_Id = B.Party_Site_Id
1352: AND B.Site_Use_Type = 'SHIP_TO'
1353: AND B.Primary_Per_Type = 'Y'