APPS.QOT_DEFAULT_PVT dependencies on HZ_PARTY_SITES

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 906: FROM HZ_PARTY_SITES

902: AND B.Status = 'A';
903:
904: CURSOR C_Get_PrAddr (l_party NUMBER) IS
905: SELECT Party_Site_Id
906: FROM HZ_PARTY_SITES
907: WHERE Party_Id = l_party
908: AND Identifying_Address_Flag = 'Y'
909: AND Status = 'A';
910:

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 1128: FROM HZ_PARTY_SITES

1124: AND B.Status = 'A';
1125:
1126: CURSOR C_Get_PrAddr (l_party NUMBER) IS
1127: SELECT Party_Site_Id
1128: FROM HZ_PARTY_SITES
1129: WHERE Party_Id = l_party
1130: AND Identifying_Address_Flag = 'Y'
1131: AND Status = 'A';
1132:

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'

Line 1359: FROM HZ_PARTY_SITES

1355: AND B.Status = 'A';
1356:
1357: CURSOR C_Get_PrAddr (l_party NUMBER) IS
1358: SELECT Party_Site_Id
1359: FROM HZ_PARTY_SITES
1360: WHERE Party_Id = l_party
1361: AND Identifying_Address_Flag = 'Y'
1362: AND Status = 'A';
1363: